[HDI] Do Full-Text Searches With MySQL?

[ibeblunt]

Today, I was reading a tutorial on MySQL's Full Text Searches.
http://www.zend.com/zend/tut/tutorial-ferrara1.php

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:
ER_FT_MATCHING_KEY_NOT_FOUND 1191 HY000

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.