Actually, by default a full text search ignores words that are three characters or less, not less than three characters.
I found this out by searching on "red". Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 One other thing - in case the restrictions page didn't mention this, fulltext by default ignores words which are less than 3 characters long. You can change this, it'll be in the docs somewhere - "ft_min_word_len". -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]