9 messages in com.mysql.lists.javaRE: Question regarding MATCH
FromSent OnAttachments
Jeff Mathis04 Aug 2004 11:45 
Mark Matthews04 Aug 2004 11:56 
Jeff Mathis04 Aug 2004 12:31 
Heikki Tuuri09 Aug 2004 10:49 
Jeff Mathis09 Aug 2004 12:40 
Heikki Tuuri10 Aug 2004 07:00 
Mufaddal Khumri10 Aug 2004 09:21 
Mufaddal Khumri26 Aug 2004 16:37 
Kevin Dougan26 Aug 2004 17:00 
Subject:RE: Question regarding MATCH
From:Kevin Dougan (kev@stepup.com)
Date:08/26/2004 05:00:28 PM
List:com.mysql.lists.java

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:mufa@wmotion.com] Sent: Thursday, August 26, 2004 7:38 PM To: <ja@lists.mysql.com> <ja@lists.mysql.com> 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=kev@stepup.com