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!
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 bring
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
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:
...
