I printed the manual, but as I am not such a database guru I was not
able to transfer this knowlegde into an select-statement. Thanks for
Is it possible to do an select-query with soundex like the following
select nn from table where nn !=''
my database has the field name (nn), I need to select every
namefield, which is not empty. So soundex should give me an result
with a list of names. How to do?
Am 31 Dec 2004 um 11:00 hat SGreen@stripped geschrieben:
> Did you think to check the manual?
> 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
> > 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: