I am using the mysql driver with mysql version 3.23.42
I have a table with the following definition
CREATE TABLE data (
id int(11) NOT NULL auto_increment,
keywords text NOT NULL,
thema text NOT NULL,
content text NOT NULL,
FULLTEXT (thema,content,keywords),
PRIMARY KEY (id))
Now I run a query like:
SELECT id, thema, content FROM faqdata WHERE MATCH
(thema,content,keywords) AGAINST ('event'');
The resultset returned is blank even though i have a sentence like -
"This is the final event for this year". in the faqdata.content column.
Any clues as to what is going wrong?
Thanks,