RE: Retrieving partial field values

[Andy Eastham]

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
> 
> 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 <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=Mary Elizabeth
> > Return Marg Elizabeth where GivenNames=Marg Elizabeth
> 
> 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
> 
> Regards, Jigal.
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
> 
> 
> 
> 
> ---------------------------------
> Do you Yahoo!?
>  All your favorites on one personal page  Try My Yahoo!