[RESOLVED] where or where

[fr8]

SELECT *  FROM `thedatabase` WHERE `site` LIKE 'aaa' OR `site` LIKE 'bbb' OR `site` LIKE 'ccc' OR `site` LIKE 'ddd'

Is there a better way of doing this kind of query?

[dagon]

since your not using wild cards for your LIKE

WHERE site in('aaa','bbb')

the manual will explains how this works.

[fr8]

That's much simpler. Thank you.