OK, I appear to be getting somewhere with the FULL TEXT search. Does anyone have any good resources about producing search engine type results ? for example if some enters a search phrase like londn how would I suggest the word london ?
> From: [EMAIL PROTECTED]> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]> CC: > mysql@lists.mysql.com> Subject: RE: Search Engine type search> Date: Wed, 23 > Aug 2006 12:18:59 -0400> > Actually, by default a full text search ignores > words that are three> characters or less, not less than three characters.> > > I found this out by searching on "red".> > Regards,> > Jerry Schwartz> Global > Information Incorporated> 195 Farmington Ave.> Farmington, CT 06032> > > 860.674.8796 / FAX: 860.674.8341> > > One other thing - in case the > restrictions page didn't mention this,> fulltext by default ignores words > which are less than 3 characters long.> You can change this, it'll be in the > docs somewhere - "ft_min_word_len".> > > > > -- > MySQL General Mailing List> > For list archives: http://lists.mysql.com/mysql> To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED]> _________________________________________________________________ Be one of the first to try Windows Live Mail. http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d
