multiple WHERE in mySQL

[wwfc_barmy_army]

Hello,

 

I just thought i'd check but i can't seem to find any information anywhere,

 

Can you replace a query like this:

SELECT * FROM tablename WHERE name = "name" OR name = "name2" OR name = "name3"

 

with something like;

SELECT * FROM tablename WHERE name = "name", "name2", "name3"

 

or some shorthand way of having multiple where conditions on the same column?

 

Thanks.

[suresh_kamrushi]

You can do like this

SELECT * FROM tablename WHERE name IN ("name", "name2", "name3") 

 

Thanks

[wwfc_barmy_army]

Legend. Thanks.

 

I'll give it a go