From: Date: August 27 2004 1:38am
Subject: Question regarding MATCH
List-Archive: http://lists.mysql.com/java/7818
Message-Id: <FB65929C-F7B8-11D8-BD08-000A95AA735C@wmotion.com>
MIME-Version: 1.0 (Apple Message framework v619)
Content-Type: text/plain; charset=US-ASCII; format=flowed
Content-Transfer-Encoding: 7bit

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,