Paul,
You can do the following:
SELECT * FROM tablename WHERE columname IN ('Bob','Mike','Betty');
Kevin
> -----Original Message-----
> From: Paul Fine [mailto:pfine@stripped]
> Sent: Friday, July 23, 2004 3:01 PM
> To: mysql@stripped
> 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!
>
>