How to Create a FULLTEXT index on MySQL Table for Fulltext Match Search

264

To setup a table to work with a MySQL FULLTEXT Match query, you must first match sure the table is MyISAM. You can alter your table using this query:

ALTER TABLE `table_name` ENGINE=MyISAM;

Next you need to create an index of fields want to search through. You can use this query as an example:

ALTER TABLE `table_name` ADD FULLTEXT `index_name` (`field_name_1`,`field_name_2`,`field_name_3`,`field_name_4`);

Now you can run a match query!

Article written by developer and designer Randy Apuzzo

If you found this post useful click the share this button. Contribute below by adding a comment, no registration is required.

There are no comments yet...Kick things off by filling out the form below.

Design Code Execute