Hi!
On Aug 22, Marty McCoy wrote:
> Hi,
>
> I'm performing a FULLTEXT search against varchar columns of one of our
> tables. One of our columns contains embedded serial numbers such as
> "02-123456" and "04-234567". The problem that when I do a FULLTEXT search
> against "02-123456", it brings back results with the following values:
>
> ... 99-123456 ...
> ... 01-123456 ...
> ... 02-123456 ...
> ... 05-123456 ...
>
> etc.
>
> First of all, I would like it only to bring back the exact match. But
> what's even more puzzling to me is that I would expect that the record
> containing the "02-123456" would have a higher MATCH value than the rest,
> since it matched 'exactly' and the others only partially matched. But
> often times other serial numbers have higher MATCH values than the exact one.
It's because 02 is too short and is simply ignored
> I'm assuming that the hyphen is messing up the search, that it, it's using
> it as a word delimiter or something like that. Is there a way to "escape"
> the hyphen, that is, make it a significant part of the search? Is there
> something that I could edit in myisam/ftdefs.h (or somewhere else) that
> would do what I would like?
Sure thing.
In the beginning of myisam/ftdefs.h there is
#define HYPHEN_IS_DELIM
change #define to #undef
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/
---------------------------------------------------------------------
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
