[SOLVED] Can't find FULLTEXT index matching the column list
Posted: Thu Oct 07, 2004 4:34 pm
This is my SQL code:
And this is SHOW CREATE of the table - > mudcrawl :
So it give me the error
if I want to query that sql. I did't understand what to do, because i already gave the FULLTEXT index to all my columns.. What is wrong with it?
Code: Select all
SELECT *, MATCH (keywords) AGAINST ('".addslashes($query)."') AS score FROM mudcrawl WHERE MATCH (keywords) AGAINST ('".addslashes($query)."' IN BOOLEAN MODE)Code: Select all
# Host: localhost
# Database: mudsearch
# Table: 'mudcrawl'
#
CREATE TABLE `mudcrawl` (
`filename` varchar(200) default NULL,
`fileurl` varchar(200) default NULL,
`keywords` longtext,
FULLTEXT KEY `keywords` (`keywords`,`filename`)
) TYPE=MyISAM;Code: Select all
Can't find FULLTEXT index matching the column list