i use mysql.
i created a table with varchar and text fields. then i inserted values into it. then i created fulltext index for this. while creating full text index, i gave the index name as \'my_index\'. now when i perform full text search on these columns i get the error:
Can\'t find FULLTEXT index matching the column list
my query is:
$query = \"select gmid,title, MATCH(title) AGAINST (\'$q\') FROM gmcheats\";
i had created full text index for \'title\'.
i created a table with varchar and text fields. then i inserted values into it. then i created fulltext index for this. while creating full text index, i gave the index name as \'my_index\'. now when i perform full text search on these columns i get the error:
Can\'t find FULLTEXT index matching the column list
my query is:
$query = \"select gmid,title, MATCH(title) AGAINST (\'$q\') FROM gmcheats\";
i had created full text index for \'title\'.