Stability of mysql-5.0.2-alpha-win

2005-01-03 Thread Raphael Matthias Krug
Hi, one more problem. The database-version above crashes, whenever I try to work with it. Work means, that I like to look at a table via php-myadmin. In this moment, the database crashes. I know that alpha is with bugs, 5.0.0 runs stable so far, but does not support views... Thanks for jus

Re: use of soundex in queries

2005-01-01 Thread Raphael Matthias Krug
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

Re: use of soundex in queries

2004-12-31 Thread Raphael Matthias Krug
... > 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

use of soundex in queries

2004-12-31 Thread Raphael Matthias Krug
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