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.
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?
Thanks,
Marty
---------------------------------------------------------------------
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
