Did you think to check the manual?
and your query would look like
WHERE SOUNDEX(field1) = SOUNDEX(field2)
because you want to compare the "sound" of both fields to see if they are
nearly the same.
Unimin Corporation - Spruce Pine
"Raphael Matthias Krug" <r.krug@stripped> wrote on 12/31/2004 10:46:06
> 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
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1