full Text search in mysql

full Text search in mysql 



MySQL supported FULLTEXT indexes 3.23.23.VARCHAR and TEXT Columns that have been indexed with FULLTEXT can be used with special SQL statements that perform the full text search in MySQL.

ALTER TABLE test_tab ADD FULLTEXT(title, body);
Once you have done  FULLTEXT index, you can search it using MATCH and AGAINST statements. For example:

SELECT * FROM test_tab
WHERE MATCH ((title, body) AGAINST ('body content');
The result of this query is automatically sorted by relevancy.

some case not support fulltext index because Full-text indexes can be used only with MyISAM