Select Code to Download

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