Am 02.01.2012 16:33, schrieb Biz-comm:
> 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.
> Using this:
> SELECT *
> FROM listings
> 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.
how should mysql know that the OR-clauses are meant not standalone?
WHERE listing_state = 'DC'
AND listings.listing_show ='y'
AND (listings.cat1 = 23 OR listings.cat2 = 23 OR listings.cat3 = 23)
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc