Check out example codes for "sql searching via key word". It will help you in understanding the concepts better.

Code Example 1

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

Code Example 2

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

Learn ReactJs, React Native from akashmittal.com