From: Date: August 27 2004 2:00am
Subject: RE: Question regarding MATCH
List-Archive: http://lists.mysql.com/java/7819
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

If you only have a few rows that match (or maybe its > 50% of the rows that
match) it won't return anything unless you include the "in boolean mode"
directive.

You also have to repeat your MATCH condition twice.

This query should work for you:

SELECT id, thema, content, MATCH (thema,content,keywords) AGAINST ('event'
in boolean mode) as score FROM faqdata WHERE MATCH (thema,content,keywords)
AGAINST ('event' in boolean mode) order by score desc;

Cheers!
Kevin


-----Original Message-----
From: Mufaddal Khumri [mailto:mufaddal@stripped] 
Sent: Thursday, August 26, 2004 7:38 PM
To: <java@stripped> <java@stripped>
Subject: Question regarding MATCH

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,


-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/java?unsub=kevin@stripped