Page 1 of 1

[SOLVED] Can't find FULLTEXT index matching the column list

Posted: Thu Oct 07, 2004 4:34 pm
by mudkicker
This is my SQL code:

Code: Select all

SELECT *, MATCH (keywords) AGAINST ('".addslashes($query)."') AS score FROM mudcrawl WHERE MATCH (keywords) AGAINST ('".addslashes($query)."' IN BOOLEAN MODE)
And this is SHOW CREATE of the table - > mudcrawl :

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;
So it give me the error

Code: Select all

Can't find FULLTEXT index matching the column list
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?

Posted: Thu Oct 07, 2004 4:45 pm
by mudkicker
Ok i have solved my problem by addin seperate fulltext indexes to my columns. i can do it bacuse i use boolean mode... look @mysql manual ;)