This sounds like a good candidate for the two-table model:
Table 1 contains an ID and the basic names.
Table 2 contains the 1-many relationship of basic name entry mapped to
all the variants - one record per variant.
So you might have Table 1 containing
ID, Prefix, GivenNames, Surname, Suffix
A full-text search won't work. Too many records -- at least 8 million. From
what I've read, full-text won't pick up the individual initials or very short
names, like Vu, Lee, Doe, etc.
Jigal van Hemert [EMAIL PROTECTED] wrote: Example a (GivenNames): Mary
Elizabeth or Marg Elizabeth
Example b
From: Kentucky Families
A full-text search won't work. Too many records -- at least 8 million.
From what I've read, full-text won't pick up the individual initials or very
short names, like Vu, Lee, Doe, etc.
You can set the ft_min_word_len in an option file in the [mysqld] section to
change
From: Kentucky Families
A full-text search won't work. Too many records -- at least 8 million.
From what I've read, full-text won't pick up the individual initials or very
short names, like Vu, Lee, Doe, etc.
You can set the ft_min_word_len in an option file in the [mysqld] section to
change
After hearing both sides being suggested, I think I would recommend the
more normalized approach of having one or more separate tables for the
names (one name per row) and a mapping table that associates a name field
(mother's maiden name, decedent's given name, decedent's surname, etc.) on
a
On Wed, 5 Jan 2005 08:19:07 -0800 (PST)
Kentucky Families [EMAIL PROTECTED] wrote:
This is a huge database so the option of using LIKE to bring up
everything beginning with the search term will result in too many
hits. I need a way to isolate these entries and search them on whole
words.
If
applications. Note you have to delete the index and rebuild it if you
change this value.
Best regards,
Andy
-Original Message-
From: Kentucky Families [mailto:[EMAIL PROTECTED]
Sent: 06 January 2005 14:05
To: Jigal van Hemert; mysql@lists.mysql.com
Subject: Re: Retrieving partial field values
Very new to MySQL and this list. Thanks in advance for your patience with
elementary questions. I'm in process of converting a current web site to a
mysql database. As this database will eventually contain millions of records, I
want to set it up properly.
The database will contain
Kentucky Families wrote:
Very new to MySQL and this list. Thanks in advance for your patience with
elementary questions. I'm in process of converting a current web site to a
mysql database. As this database will eventually contain millions of records, I
want to set it up properly.
The database
On Wed, 05 Jan 2005 12:22:18 +
Stephen Moretti [EMAIL PROTECTED] wrote:
Kentucky Families wrote:
... If I use a VARCHAR or TINYEXT field to enter these values and
I want to be able to retrieve all records where the surname field
contains the whole word Stotts, how would I enter these
Ian Grant wrote:
On Wed, 05 Jan 2005 12:22:18 +
Stephen Moretti [EMAIL PROTECTED] wrote:
Kentucky Families wrote:
... If I use a VARCHAR or TINYEXT field to enter these values and
I want to be able to retrieve all records where the surname field
contains the whole word Stotts, how
Stephen Moretti [EMAIL PROTECTED] wrote on 01/05/2005 07:22:18 AM:
Kentucky Families wrote:
Very new to MySQL and this list. Thanks in advance for your
patience with elementary questions. I'm in process of converting a
current web site to a mysql database. As this database will
Thanks to everyone who has responded to this. I still don't have an answer that
will work, so here is a bit more information:
1) The name fields are divided into 4 parts:
Prefix, GivenNames, Surname, Suffix
3) The GivenNames field already has more than one word in many instances.
Sample
Example a (GivenNames): Mary Elizabeth or Marg Elizabeth
Example b (GivenNames): J. W. or I. W.
Example c (Surname): Stotts, Statts or Stutts
I need to be able to retrieve the following based upon the examples:
For Example a:
Return Mary Elizabeth where GivenNames begins with M;
Return
14 matches
Mail list logo
