HOW TO ADD FULLTEXT INDEX TO A COLUMN IN MYSQL TABLE
Here given the example which is based on a test table "tbl_Products"
How to Create MySQl table with Full-Text indexed columns?
To create a table with Full-Text indexed columns, use query like this:
CREATE TABLE tbl_Products ( `Product_Id` int(11) NOT NULL auto_increment, `Product_Title` varchar(150) , `Product_Details` Text, PRIMARY KEY (`Product_Id`), FULLTEXT KEY `Product_Title` (`Product_Title`,`Product_Details`) ) ENGINE=MyISAM
How to add Fulltext index to a column of an existing table?
To Add Full-Text index to a column of an already created table, use query like this:
ALTER TABLE tbl_Products ADD FULLTEXT(Product_Title, Product_Details);
In the above SQL statement we are adding Fulltext indexes to 2 columns (ie, "Product_Title" and "Product_Details" ) of table "tbl_Products"
MYSQL FULL-TEXT SEARCH QUICK REFERENCE GUIDE
