List:MySQL and Java« Previous MessageNext Message »
From:Mufaddal Khumri Date:August 27 2004 1:38am
Subject:Question regarding MATCH
View as plain text  
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,

Thread
timestampsJeff Mathis4 Aug
  • Re: timestampsMark Matthews4 Aug
    • Re: timestampsJeff Mathis4 Aug
  • Re: timestampsHeikki Tuuri9 Aug
    • Re: timestampsJeff Mathis9 Aug
  • Re: timestampsHeikki Tuuri10 Aug
    • Problem with migrating from 4.0 to 4.1 ?Mufaddal Khumri10 Aug
    • Question regarding MATCHMufaddal Khumri27 Aug
      • RE: Question regarding MATCHKevin Dougan27 Aug