Perfect. Thanks so much. On Jan 2, 2012, at 10:40 AM, Mike OK wrote: > Hi Patrice > > 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 = 23 ) > > Mike >
Regards, Patrice Olivier-Wilson 828-628-0500 http://Biz-comm.com b...@biz-comm.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
