Re: ignore words in full text indexes

2002-02-28 Thread David yahoo
Hi, > Or maybe there are too many. It appears that any word that appears > in more than half the rows is treated as a stop word: > > http://www.mysql.com/doc/F/u/Fulltext_Search.html > I read this page but this condition doesnt hurt my mind. I don t know what happen I modify fait to fiato I reg

Re: ignore words in full text indexes

2002-02-28 Thread Keith C. Ivey
Sergei Golubchik wrote: > On Feb 28, David yahoo wrote: > > 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 ? > > may be there're no rows with "fiat" ? :) Or maybe there are t

Re: ignore words in full text indexes

2002-02-27 Thread Sergei Golubchik
Hi! On Feb 28, David yahoo wrote: > 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 (

RE: ignore words in full text indexes

2002-02-27 Thread Daniel Rosher
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 word