sql searching via key word
snippet in sql

sql searching via key word

user6119

SELECT id, description
FROM table
WHERE MATCH (description) AGAINST('keyword1 keyword2')

sql searching via key word

user299

SELECT id, category, location
FROM table
WHERE
(
    category LIKE '%keyword%'
    OR location LIKE '%keyword%'
)