problem with multiple conditions

Hi
I have a problem with multiple queries and hope I can convey myself clearly.

say I have to select part of a table

SELECT * FROM mytable WHERE condition1 OR condition2 AND condition3 OR condition4

PHP:

But this doesn't give what I want, It seems that sql interpret it with "condition1 OR condition2 OR condition3 OR condition4".

what I want is the equivalent of this (condition1 OR condition2) AND (condition3 OR condition4). Any idea?

 

Just use
(condition1 OR condition2) AND (condition3 OR condition4)

you were so close..

 

yep, use the parens to force the way the expressions are evauled. If you are sloppy, hehe, like that was, you get the mysql interprutation of the order of presidence.

 

Thanks

I didn't test it because I though it was so good to be true to me.