David, I think the nominal minimum word length is 4 so 'fiat' will not be indexed.
This can be modified however. regards, Dan > -----Original Message----- > From: David yahoo [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 28 February 2002 12:28 p.m. > To: [EMAIL PROTECTED] > Subject: ignore words in full text indexes > > > Hi all, > > I m using mysql 4.01 alpha > > I read in the doc : > "MySQL uses a very simple parser to split text into words. A > ``word'' is any > sequence of letters, numbers, `'', and `_'. Any ``word'' that is > present in > the stopword list or just too short (3 characters or less) is ignored. " > > My queries let me devine that <=4 words are ignored. > > How to know more. > > SELECT * FROM T_Stories WHERE match .... against ('+fiat -bagnole' IN > BOOLEAN MODE) > doesnt give any row > but when changing fiat to fiato it gives me row ? > > I regenerate the index beetween queries -> nothing ? > > Is there any easy way planed fro changing stopword and words min length in > the future ? > By an easy way I didint want to recompile a mysql server only > changing some > files or syetem database, > like the mysql database is ? > > > Thanks. > Regards. > > _________________________________________________________ Do You > Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
