Just a thought - if your serial numbers have fixed format, then
programmatically remove the hyphen and store the number without it. Add it
back when displaying data on the screen. That way FULLTEXT will work on the
whole number without splitting it into two parts.
Vadim.
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.
>
> 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
---------------------------------------------------------------------
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
