MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Paul Fine Date:July 23 2004 10:00pm
Subject:Another newbie question - using OR in WHERE clauses
View as plain text  
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!


Thread
Another newbie question - using OR in WHERE clausesPaul Fine23 Jul
  • RE: Another newbie question - using OR in WHERE clausesKevin Ward24 Jul
  • Re: Another newbie question - using OR in WHERE clausesScott Haneda24 Jul
RE: Another newbie question - using OR in WHERE clausesHardik Doshi24 Jul