[Date Prev][Date
Next][Thread Prev][Thread Next][Date
Index][Thread Index]
[OT] MySql Soundex
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
Home |
Main Index |
Thread Index
|