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.
basic math
how should mysql know that the OR-clauses are meant not standalone?
SELECT *
FROM listings
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
