one of
my 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:
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.
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 r
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
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
> Exampl
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
> 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;
> R
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
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
>
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 wou
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 ente
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 w
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 transcripti
14 matches
Mail list logo
