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)
signature.asc
Description: OpenPGP digital signature