If you searched for '% john %' - note the spaces, you would not find
'johnson' etc..
-----Original Message-----
From: Matthew Brealey [mailto:[EMAIL PROTECTED]]
Sent: Tue, 26 June 2001 11:29
To: [EMAIL PROTECTED]
Subject: Full text search gotchas
We're having quite a lot of difficulty with MySQL's fulltext search. The
problem is that it does partial matches. E.g., john matches johnson. Thus
a match of author against dickens takes about 0.09 seconds with a 700,000
record table, but a match of a shorter word takes a good deal longer - a
four-letter word takes several seconds.
Does anyone know whether it's possible to change this so substring matches
(such as john against johnson) are NOT made? (Perhaps someone has a patch
or a suggestion as to how to make this work.)
Also, having incidentally changed ftdefs.h to match 3-letter words, is it
now necessary to rebuild the fulltext indexes?
=====
____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
