Select This or That

[SharkBait]

Hi,

I have a MySQL query that looks like this:

SELECT * FROM test where test1 = 'Y' OR test 2 = 'N' AND testname = 'MINE'

Now I understand that is wrong, but I am not sure how to make the query do what I want.

I want to make the query true if test1 = Y OR test2 = N or even both.

How can do this properly?

[onepixel]

How about
SELECT * FROM test where (test1 = 'Y' OR test 2 = 'N') AND testname = 'MINE'

[SharkBait]

[!--quoteo(post=368987:date=Apr 26 2006, 01:40 PM:name=onepixel)--][div class=\'quotetop\']QUOTE(onepixel @ Apr 26 2006, 01:40 PM) [snapback]368987[/snapback][/div][div class=\'quotemain\'][!--quotec--]
How about
SELECT * FROM test where (test1 = 'Y' OR test 2 = 'N') AND testname = 'MINE'
[/quote]

Thats what I thought. Hehe silly me.

Thanks