A clean way to write this MySQL query?

Question

A clean way to write this MySQL query?

This is my current request:

SELECT * FROM users
WHERE blah blah...
AND users.who = '1'

AND users.seeking = '2' 
OR users.seeking = '5' 
OR users.seeking = '8' 
OR users.seeking = '9' 
OR users.seeking = '11' 
OR users.seeking = '13' 
OR users.seeking = '14' 
OR users.seeking = '15' 

AND users.account_status = '1';

As you can see, the search field can have several values. Instead of writing so many ORs, is there a nicer way to specify all valid values for this field to be returned by my select statement?

+3

mysql

TK123 May 05 '12 at 16:47

source share

1 answer

mgraph · Accepted Answer · 2012-05-05T16:48:40+0000

SELECT * FROM users
WHERE blah blah...
AND users.who = '1'

AND users.seeking IN('2','5','8','9','11','13','14','15') 
AND users.account_status = '1';

A clean way to write this MySQL query?

More articles: