Home  »     »     »  HOW TO ADD FULLTEXT INDEX TO A COLUMN IN MYSQL TABLE

HOW TO ADD FULLTEXT INDEX TO A COLUMN IN MYSQL TABLE

Tuesday, March 19, 2013

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



How to link to this page?
If you wish to link to this page from your website, simply Copy and paste the above HTML code to your web page. It will appear on your page as:
HOW TO ADD FULLTEXT INDEX TO A COLUMN IN MYSQL TABLE.




Share this!




comments powered by Disqus

This Weeks 7 Popular Posts


Subscribe to Recent Posts by Email
Stay connected to CROZOOM with regular Email notices of new Techie articles and IT Jobs. Updates will be delivered to your Inbox as soon as they are posted online.

Enter Your Email Address:  

Delivered by FeedBurner   RSS Feed

Search this Blog   



Urgent Openings for PHP trainees, Andriod / IOS developers and PHP developers in Kochi Trivandrum Calicut and Bangalore. Please Send Your updated resumes to recruit.vo@gmail.com   Read more »