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