On Wed, 22 Aug 2001, Marty McCoy wrote:
> 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:
I'm guessing that you have a VARCHAR column that lists multiple serial
numbers.
Have you thought about splitting this into a different table that has just
one serial number per row? This would be better for efficiency and you can
also match the serial numbers exactly. The FULLTEXT method that you are
using seems an awkward way to do this.
(I'd answer the question you asked, but I don't know how to set the
delimiter for FULLTEXT. It would make sense that you can do something
about it---otherwise people couldn't search for words like "CD-ROM".
Maybe someone else can shed some light on this.)
---------------------------------------------------------------------
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
