Re: [OT] MySql Soundex

[Doogie Brodie <ukhad@xxxxxxxxxxxxxxxx>]

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