Sql searching via key word

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%'
)

This article is tagged with: Sql searching via key word and mysql