SELECT name, address, city, phone
FROM valley
WHERE keywords LIKE '%$search%'
OR category LIKE '%$search%'
ORDER BY name LIMIT %d,%d"

##</code><code>##

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