and or

howdy,
i come across something thats buggin me, I have a search engine type thing that has two different fields and if they fill in both, i want it to find stuff matching that matches them, but it doesnt have to matche them both.
ie. I want a query that would work to the effect of :
SELECT * FROM plants WHERE bot_name LIKE '%$bot%' AND OR comm_name LIKE '%$com%'
however, obviously this doesnt work..anyone know of how to do this? I can achieve it with some if statements, just wanna know if you can do it in the query...

SELECT * FROM plants WHERE bot_name LIKE '%$bot%' OR comm_name LIKE '%$com%'

this will match if both match or either one matches...

hehe, well would ya look at that, it does too... :uhoh: