15 messages in com.mysql.lists.mysqlRe: fulltext searching
FromSent OnAttachments
Marko Djukic01 Jul 2002 03:42 
Sergei Golubchik01 Jul 2002 05:07 
Erlend Hopsø Strømsvik02 Jul 2002 01:26 
Eivind A. Sivertsen02 Jul 2002 02:22 
Marko Djukic02 Jul 2002 02:28 
Peter Lovatt02 Jul 2002 02:44 
Eivind A. Sivertsen02 Jul 2002 03:00 
Egor Egorov02 Jul 2002 03:01 
Thomas Spahni02 Jul 2002 03:26 
Marko Djukic02 Jul 2002 03:26 
Marko Djukic02 Jul 2002 03:28 
Eivind A. Sivertsen02 Jul 2002 04:18 
Sergei Golubchik02 Jul 2002 06:56 
Marko Djukic26 Jul 2002 00:38 
Marko Djukic26 Jul 2002 09:56 
Subject:Re: fulltext searching
From:Marko Djukic (mys@oblo.com)
Date:07/01/2002 03:42:42 AM
List:com.mysql.lists.mysql

hi all...

i can't seem to get the fulltext searching working perfectly... single search
terms it works fine, multiple search terms it also seems to be ok - finding
records with any of the search terms. however, if i try the boolean mode it gives out garbage all the time. i try for
example an sql query like this: select * from mytable where match(file_text) against('+findthis +andthis
-notthis' in boolean mode);

various variants of this never find the records, or find ALL the records in the
database... when such filters should throw out a couple of records at least. i'm running mysql 4.0.1-alpha on freebsd...  and i've set up the tables for
fulltext indexes.

is this still heavy work-in-progress or should it work? does it work for anyone?

thanks,

marko