Stability of mysql-5.0.2-alpha-win
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 just a feedback, if I am the only one with this problem. I looked in the archive and saw that one or two had similiar problems. I work with XP-Home. Do you already know when the 5.0.3alpha will be released? Raphael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: use of soundex in queries
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 effect relationship, though, but trying to go printless might activate something that speeds up skill acquisition. I just printed the soundex-parts. This was ten lines :-). For understanding my problem, see the text below. Shawn & Sasha I am working with medieval sources, so called taxbooks. They contain names, taxamounts and other administrative entries. For my research I took nine of these taxbooks. One of my aims is to find out, if many taxpayers died or moved or simply stayed, e.g. with diseases. For this purpose, I inserted every taxbook in one table. To compare the persons in this book, a friend created a php-script/file which takes from one book the names and compares them with the other books using right now a normal select-statement. The result is on the left a name and then as a table for each taxbook a row and if the name appears a 1. From a colleague I heard now about soundex. This would make it easier to compare these odd-writen names (so to say; the same person can appear as Myer, Mair, Meyer etc.). Therefore I asked how to implement this into a select-statement. Do you see any better ideas doing this, then with a php-file? The script right now has the disadvantage, that it does not check, if the names show up in the order. But I think, this could be fixed with an additional select-statement in the php-file. Sorry, it got a bit long. Thanks in advance Raphael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: use of soundex in queries
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 [EMAIL PROTECTED] 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" <[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]
> >
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
use of soundex in queries
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]
