boolean query from ONE table

This is probably a simple problem but here it is:

I want to have 2 conditionals in the WHERE part of my MySql query. Basically I want to go:

SELECT * FROM sometable WHERE day LIKE "monday" && food LIKE "pizza"

I'm pretty sure that's not how you do it, but I think you understand my point.

Thanks in advance,

Retsigam

SELECT * FROM sometable WHERE day LIKE "monday" AND food LIKE "pizza"

try that.

SELECT * FROM sometable WHERE day='monday' AND food='pizza'

that will only work if you want them to match exactly, like will give you close matches

Thanks guys. I appreciate it a lot!