full text search query mysql code example

Example 1: text search in mysql

SELECT * FROM table_name WHERE MATCH(col1, col2)
AGAINST('search terms' IN NATURAL LANGUAGE MODE)

Example 2: enable full text search mysql

ALTER TABLE table_name  
ADD FULLTEXT(column_name1, column_name2,…)