use of soundex in queries

[Raphael Matthias Krug]

Hi,

I need to compare names from different tables and therefore I need 
to know the proper use of soundex. I googled for it, but could not find 
anything useful. And select soundex('text') is no help for me.

The query should look like this:
select field from table where field like [soundexquery inserted]

As result there should be a list with the names. The comparison of 
the table can also be done with php, so mainly it would be great to 
know how to do resultqueries as described.

Thanks for help! Happy new year

Raphael