From: Date: January 6 2005 4:52pm
Subject: RE: Retrieving partial field values
List-Archive: http://lists.mysql.com/mysql/178151
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,

Full text search should be fine with 8 million records.  These are short
records too, so there shouldn't be any problem at all.

Also, you can configure the minimum word length in the my.cnf file, so =
if
you want it to find short words, you can.  I've got it set to two in 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:kyfamilies@stripped]
> Sent: 06 January 2005 14:05
> To: Jigal van Hemert; mysql@stripped
> Subject: Re: Retrieving partial field values
>=20
> 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.
>=20
> Jigal van Hemert <jigal@stripped> wrote:> 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 Marg Elizabeth where GivenNames begins with M;
> > Return Mary Elizabeth where GivenNames contains the whole word Mary;
> > Return Marg Elizabeth where GivenNames contains the whole word Marg;
> > Return Mary Elizabeth where GivenNames=3DMary Elizabeth
> > Return Marg Elizabeth where GivenNames=3DMarg Elizabeth
>=20
> I'm beginning to think that a form of FULL TEXT search is what you =
need;
> take a look at these articles:
> http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html
> http://dev.mysql.com/doc/mysql/en/Fulltext_Boolean.html
> and even query expansion might be usefull in your case (though it =
might be
> a
> bit slow):
> http://dev.mysql.com/doc/mysql/en/Fulltext_Query_Expansion.html
>=20
> Regards, Jigal.
>=20
>=20
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =
http://lists.mysql.com/mysql?unsub=3Dkyfamilies@stripped
>=20
>=20
>=20
>=20
> ---------------------------------
> Do you Yahoo!?
>  All your favorites on one personal page =16 Try My Yahoo!