Re: full-text search with '&'

[Tony McCreath]

I would guess the AT&T in the index itself is treated as two words "AT" and "T" both of which would be ignored as they are less than 3 characters.

I had a similar problem. My solution was to create a special `searchwords` field in the database where I would gather and store all the searchable words from a row.

Doing this let me manipulate the words as I did it. My manipulation finds all the subwords (seperated by special characters) and outputs them sperately and concatinated.

For example:

"AAAA-BBBB&CC" => "AAAA BBBB CC AAAABBBBCC"

in your case:
"AT&T" => "AT T ATT"

Doing a similar trick on the words used in the search and you would get your match with "ATT".

Tony