Hi!
On Aug 05, Justin Hopper wrote:
> On Tue, 2003-08-05 at 10:57, Paul DuBois wrote:
> > At 10:30 -0700 8/5/03, Justin Hopper wrote:
> > >
> > >I have a table with a FULLTEXT index on a column of type 'text'.
> > >Searches on this table using MATCH() AGAINST() work fine for most
> > >words. However, I needed to match against a 3 letter word. So I
> > >lowered the ft_min_word_len to 3 in /etc/my.cnf. I then restarted
> > >MySQL. I checked that the variable was set to 3 in the running mysqld.
> >
> > >mysql> select title_id from support_doc_articles where match(article)
> > >against ('dns');
> > >Empty set (0.00 sec)
> > >
> > >It does not work IN BOOLEAN MODE either:
> > >
> > >mysql> select title_id from support_doc_articles where match(article)
> > >against ('dns' IN BOOLEAN MODE);
> > >Empty set (0.00 sec)
> > >
> > >Actually, I just tried it again, searching for the 3 letter word 'key',
> > >and it brought back results. Is 'dns' in the stopwords list? Is there
> > >any way I can see what words are in there? Can I exclude words from the
> > >stopword list without recompiling MySQL?
> >
> > I don't believe you can exclude words from the list without recompiling.
You can, actually, there is ft_stopword_file variable.
> Hmmm, any ideas why the word 'dns' would not be picked up then?
no ideas. can you create a test case for me to try it out ?
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
