SELECT name,address,city,phone
FROM valley
WHERE CONCAT_WS(' ',keywords,category) LIKE '%Antiques Dealers%'
ORDER BY name LIMIT %d,%d 

##</code><code>##

Dealers with Antiques

##</code><code>##

SELECT name,address,city,phone
FROM valley
WHERE keywords LIKE '%Antiques%'
  AND keywords LIKE '%Dealers%'
ORDER BY name LIMIT %d,%d 

##</code><code>##

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