Results 1 to 1 of 1
Thread: Errors Doing Full Text Search
May 13, 2004, 08:14 #1
- Join Date
- Jan 2001
- Jersey City, NJ
- 0 Post(s)
- 0 Thread(s)
Errors Doing Full Text Search
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
#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.<///////~