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" <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] >
