searching sql and metaphone()

Hello everyone.

I have a complex search engine.

My question though is simple.

Could someone show me and example of how I might use metaphone in a search engine statement that uses mysql?

SELECT * from TABLE where field LIKE "%String1%" AND field LIKE
"%string2%"

where would I put the metaphone function?

As far as I know, MySql doesn't have a metaphone function but does have a SOUNDEX function. So you can

SELECT * from TABLE where (SOUNDEX(field) = ". soundex(String1) . ") OR (SOUNDEX(field) = " . soundex(string2). ")"

thanks i'm still messing with it, for some reason the soundex isn't working

But at least i'm off to a good start!!