FULL-TEXT SEARCH IN MYSQL
Full-text search helps to generate a better and relevant search result.
In MySQL Full Text searching is only supported by the MyISAM storage engine.
FULL TEXT Search is applicable to Fields having data type VARCHAR or TEXT
Full-text Searches are not case sensitive
Basically there are 2 stages of FULLTEXT Searching
Full-text searching is performed using MATCH() … AGAINST syntax.
SELECT Product_Title, Product_Details FROM tbl_Products
WHERE MATCH (Product_Title,Product_Details) AGAINST (‘MySQL DataBase’);
CLICK HERE TO KNOW HOW TO ADD FULLTEXT INDEX TO A COLUMN IN MYSQL TABLE
CLICK HERE TO KNOW HOW TO REMOVE FULLTEXT INDEX FROM A COLUMN IN MYSQL TABLE
CLICK HERE TO KNOW VARIOUS OPTIONS IN FULL-TEXT SEARCH
MYSQL FULLTEXT SEARCH – QUICK REFERENCE GUIDE – ADDING AND REMOVING OF FULL-TEXT INDEX.