This article is tagged with:
Sql searching via key word
and mysql
sql searching via key word
SELECT id, description
FROM table
WHERE MATCH (description) AGAINST('keyword1 keyword2')
sql searching via key word
SELECT id, category, location
FROM table
WHERE
(
category LIKE '%keyword%'
OR location LIKE '%keyword%'
)