mysql keyword search

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

1SELECT id, category, location
2FROM table
3WHERE
4(
5    category LIKE '%keyword%'
6    OR location LIKE '%keyword%'
7)

1SELECT title, description
2FROM film
3WHERE
4(
5    title LIKE '%Drama%'
6    OR description LIKE '%Drama%'
7);
8