From: Dan Nelson
Date: April 12 2006 5:56pm
Subject: Re: Fulltext and reserved words
List-Archive: http://lists.mysql.com/mysql/196822
Message-Id: <20060412175603.GB89228@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
In the last episode (Apr 12), Taco Fleur said:
> I am in need to search for sql reserved words with MATCH AGAINST it
> turns it doesn't return anything when I feed it a reserved word like
> 'sql' is there anything I can do about that?
By default the full-text indexer skips words less than four characters
long. If you set ft_min_word_len=3 and rebuild your index, "sql" should
get indexed.
http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html
--
Dan Nelson
dnelson@stripped