FULLTEXT and MySQL 4.0
Hi,
I'm having a minor issuette with full text searching in MYSQL (version 4.0.23).
I have added fulltext index onto the columns I want
FULLTEXT KEY `search` (`articles_titletext`,`articles_text`),
However, when I run a query such as
select * from articles where match(articles_text) against ('{search term}');
I get...
Can't find FULLTEXT index matching the column list
Now, the index is there fine, I can see it when I describe the table.
Any ideas where the problem lies?
thanks
Joel Hughes
Subject
Views
Written By
Posted
FULLTEXT and MySQL 4.0
3284
March 19, 2007 05:16AM
2303
May 01, 2007 09:20AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.