SQL Where Statement

[jason360]

Hey guys,

 

I am not sure how to phrase this WHERE statement.

 

I currently have this:

WHERE approved = "1" AND item_gender="1" OR item_gender="3"

It seems to be omitting the 'approved' part.  What I require is that approved=1 must be adhered to regardless, but item_gender can be equal to 1 or 3.

 

 

Any ideas what I am doing wrong?

 

Thanks!

[Barand]

Use (..) to ensure the logic you really want

WHERE approved = "1" AND (item_gender="1" OR item_gender="3")

otherwise the logic defaults to

WHERE (approved = "1" AND item_gender="1") OR item_gender="3"

Alternatively, use IN instead of multiple ORs

WHERE approved = "1" AND item_gender IN (1, 3)

Edited March 2, 2015 by Barand