Can't find FULLTEXT index matching the column list (indexes is set)

php mysql full-text-search
LucasRolff picture LucasRolff · Mar 13, 2012 · Viewed 63k times · Source

I'm working with fulltext, I executed an command to add the fulltext index to multiple comments, and returned no errors, then I did:

SELECT * FROM products WHERE MATCH(`brand`) AGAINST('Skoda');

Which is in the brand column - but I get following:

Can't find FULLTEXT index matching the column list

Eventho, when my table looks like this:

FULLTEXT KEY `name` (`name`,`breadcrumb`,`description`,`brand`,`price`,`year`,`km`,`usage`,`type`)

Is it because I should use the name instead? to do the search? Or what can be wrong.

Answer

jerrymouse picture jerrymouse · Mar 13, 2012

Assuming you are using MyISAM engine, Execute:

ALTER TABLE products ADD FULLTEXT(brand);

The fulltext index should contain exactly the same number of columns, in same order as mentioned in MATCH clause.

Related questions

PHP mysql search multiple tables using a keyword

I have three tables in my database which are: messages topics comments Each of these tables has two fields called 'content' and 'title'. I want to be able to use 'Like' in my sql statement to look at 'messages.content', …

Read More
How to sort MYSQL fulltext search results by relevancy

I am relatively new to MYSQL and have had an issue that has been bugging me for a while. I've tried googling all over the place for the answer, but have unable to find an acceptable solution as of yet. …

Read More
Best way to deal with misspellings in a MySQL fulltext search

I have about 2000 rows in a mysql database. Each row is a max of 300 characters and contains a sentence or two. I use mysql's built in fulltext search to search these rows. I would like to add a feature so …

Read More