Today, I was reading a tutorial on MySQL's Full Text Searches.

I changed the column, contentheadline and contentpage_1 to Full Text columns. So I ran the following query in phpMyAdmin:

SELECT * FROM tbl_content WHERE MATCH ('contentheadline', 'contentpage_1') AGAINST ('beats') LIMIT 0 , 30
I keep getting this error:

MySQL said:

#1191 - Can't find FULLTEXT index matching the column list

I looked it up and the error is listed as:

If you're like me that doesn't mean much.

I'm using MySQL 4.0.17, PHP Version 4.3.3.

Any help is appreciated.