MySQL Forums
Forum List  »  Full-Text Search

Re: full-text search with '&'
Posted by: Tony McCreath
Date: July 28, 2005 08:06PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
3286
min
September 30, 2004 06:18PM
Re: full-text search with '&'
2410
July 28, 2005 08:06PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.