This will give you a list of names and their soundex values. Is this what
you want? What is it you are trying to do, there may be a better way to do
this than by getting a list and reprocessing it somehow.
SELECT nn, soundex(nn)
FROM table
WHERE nn > ''
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Raphael Matthias Krug" <r.krug@stripped> wrote on 12/31/2004 12:42:30
PM:
> Hi Shawn,
>
> 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
> your realtimehelp.
>
> Is it possible to do an select-query with soundex like the following
> examble?
>
> 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?
>
> Thanks
> Raphael
>
> Am 31 Dec 2004 um 11:00 hat SGreen@stripped geschrieben:
>
> >
> >
> > 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
> > >
>
>
