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!
