Jump to content

SQL Where Statement


jason360

Recommended Posts

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!

Link to comment
https://forums.phpfreaks.com/topic/295002-sql-where-statement/
Share on other sites

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)
Link to comment
https://forums.phpfreaks.com/topic/295002-sql-where-statement/#findComment-1507201
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.