SELECT name,address,city,phone FROM valley WHERE CONCAT_WS(' ',keywords,category) LIKE '%Antiques Dealers%' ORDER BY name LIMIT %d,%d #### Dealers with Antiques #### SELECT name,address,city,phone FROM valley WHERE keywords LIKE '%Antiques%' AND keywords LIKE '%Dealers%' ORDER BY name LIMIT %d,%d #### SELECT name,address,city,phone FROM valley WHERE keywords LIKE '%Antiques%Dealers' ORDER BY name LIMIT %d,%d -- if all keywords are always ordered alphabetically