I would try some brackets.
Something like this should work
SELECT * FROM listings WHERE listing_state = 'DC' AND listings.listing_show
='y' AND ( listings.cat1 = 23 OR listings.cat2 = 23 OR listings.cat3 =
----- Original Message -----
From: "Biz-comm" <biz@stripped>
Sent: Monday, January 02, 2012 10:33 AM
Subject: Beginner question
Thanks for any assistance.
Web page that needs a sort of all records with a specific state, set to
"show", and if it exists in one of 4 categories.
WHERE listing_state = 'DC'
AND listings.listing_show ='y'
AND listings.cat1 = 23 OR listings.cat2 = 23 OR listings.cat3 = 23
Gives up 2 records in the state of DC, set to show, and are listed in cat1.
However, it also gives up 2 records in the state of VA, set to show, but are
listed in cat2 (not in 1).
Any assistance most appreciated.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql