[Date Prev][Date
Next][Thread Prev][Thread Next][Date
Index][Thread Index]
Re: [OT] MySql Soundex
Hi Alex,
> Scuse the [OT] post. I'm trying to use Soundex with MySql to do some
searching on a string.
Although I've not done much more than dabble in MySQL, I've done a lot
of work with MS SQL, and I can honestly say I've never required to use
soundex so far, although I've always been interested in it.
> 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 :-)
AIUI, a soundex is calculated on a single word.
You would have to split your phrases and multiple words into seperate
words before querying for their soundex. You should be able to get away
with searching for a space delimiter and building an array or #table, or
whatever your programming language allows, and then cycling through that
comparing the soundexes.
--
Doogie
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
|