[OT] MySql Soundex

["Alex Kinch" <alex@xxxxxxxxxxxxx>]

Hi,

Scuse the [OT] post. I'm trying to use Soundex with MySql to do some
searching on a string.

Basically if I have a table with the following: Cat, Dog, Rabbit, Horse

I want it to match "Horse" when I either search for the
following:

"I have a horse in my house"

or

"I have a hurse in my house"

Soundex can take care of the misspelling, but what about matching a word
that's mid-querystring? Some entries in the table might be more than one
word, eg tabby cat, white rabbit, shire horse,etc.

Don't worry I'm not turning into a vet, just thought the animal examples
was the best way I could explain what I'm trying to do :-)

Alex

[Non-text portions of this message have been removed]



UK Home Automation Meet 2004 - BOOK NOW!
http://www.ukha2004.com

http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx
Subscribe:  ukha_d-subscribe@xxxxxxx
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx
List owner:  ukha_d-owner@xxxxxxx