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 too many. It

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

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 words in

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 (3