"James Drabb" <[EMAIL PROTECTED]> wrote on 25/05/2004 16:30:07:
> The text 'May' is in the column, yet I get no rows returned? The admins
> are looking
> to be able to search for an arbitrary string in the MsgText field that
> can be anywhere
> in the field not just at the beginning. So it seems that a regular
> index will not work,
> yet a FULLTEXT index doesn't seem to be getting all the needed data.
FullText Indexes discard short words. By default, 3 characters or less.
This can be configured by the configuration variable ft_min_word_len. Since
this controls tha adding of words to the index, you will need to reindex
after redefining it. You may want to remove very common words which yoiu do
not want indexed using the ft_stopword_file, which tells it to ignore
certain words.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
