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 clauses > > 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! > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]