I try to create a FULLTEXT index using phpMyAdmin with the Keyname as "title" with fields "title,description, and keywords". I ran the mysql query without a problem and it create a indexes below. However, everytime I perform a fulltext index search with "select count(*) from information where match (title) AGAINST ('Football') and photo = 'p' and folder =2" I got a error:

#1191 - Can't find FULLTEXT index matching the column list

Please let me know if I done something wrong.

Keyname Type Cardinality Action Field
PRIMARY PRIMARY 34053 id

title FULLTEXT 1 title
description
keywords

    you have to use the column names, not the index name as the argument for MATCH()

      Write a Reply...