IN ('Bob','Mike','Betty');
Kevin
-Original Message-
From: Paul Fine [mailto:[EMAIL PROTECTED]
Sent: Friday, July 23, 2004 3:01 PM
To: [EMAIL PROTECTED]
Subject: Another newbie question - using OR in WHERE clauses
Is there a simpler way to write something like:
SELECT * FROM
Is there a simpler way to write something like:
SELECT * FROM tablename
WHERE columname = 'Bob' OR columname = 'Mike' OR columname = 'Betty'
Clearly this does not work:
WHERE columname = 'Bob' OR 'Mike' OR 'Betty'
Thanks!
Paul,
You can do the following:
SELECT * FROM tablename WHERE columname IN ('Bob','Mike','Betty');
Kevin
-Original Message-
From: Paul Fine [mailto:[EMAIL PROTECTED]
Sent: Friday, July 23, 2004 3:01 PM
To: [EMAIL PROTECTED]
Subject: Another newbie question - using OR in WHERE
on 7/23/04 3:00 PM, Paul Fine at [EMAIL PROTECTED] wrote:
SELECT * FROM tablename
WHERE columname = 'Bob' OR columname = 'Mike' OR columname = 'Betty'
This is perfectly accurate
--
-
Scott Haneda