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
TED] > 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

ignore words in full text indexes

2002-02-27 Thread David yahoo
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