Home >> Asked Questions >> Mysql

Full text search is used to search a complete phrase in a given string.

For full text search 1st alter the table
ALTER TABLE tbl_name ADD FULLTEXT(fld_name1, fld_name2);
SELECT fld_name1, fld_name2 FROM tbl_name
WHERE MATCH (fld_name1,fld_name2) AGAINST ('text');