Hello Shane,apologies, I forgot to mention that.
Wednesday, March 31, 2004, 5:43:10 AM, you wrote:
SA> using MATCH(description) AGAINST('+db2' IN BOOLEAN MODE) returns no results. SA> Is this expected behaviour? If so, is there a way to circumvent it?
By default, the full text indexing engine doesn't include words with less than 4 characters in. If you are using MySQL 4 you can change the "minimum length" via the ft_min_word_len variable. On MySQL 3.x there's nothing you can do short of changing the actual source code and recompiling.
I was aware of this, and just finished changing the ft_min_word_length to 2 and rebuilding my indexes.
searches for 'SAS' or 'net' yield results as expected, but DB2 still does not.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]