Raphael Matthias Krug wrote:
Sasha
P.S. I have a theory that a habit of printing computer documentation
is a road block to becoming a "guru". At least, I have not yet
encountered a "guru" that printed much, while at the same time it
seems like a struggling user prints a lot. You cannot be 100% s
Raphael Matthias Krug wrote:
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.
FYI Soundex has real problems ... use DoubleMetaphone...
Ke
Sasha
P.S. I have a theory that a habit of printing computer documentation is a
road block to becoming a "guru". At least, I have not yet encountered a
"guru" that printed much, while at the same time it seems like a
struggling user prints a lot. You cannot be 100% sure about the cause and
effe
Raphael Matthias Krug wrote:
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
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
Unimi
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 h
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(fi
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 i
