Neil Tompkins wrote:
Thanks for the info. I think that problem was the fact I only had a couple of records. When creating the FULLINDEX field, does anything else happen to the field, other than the fact you can search FULLINDEX. The reason I ask is because I have about 1600 text fields which I want to apply this to.
The only thing that happens is the index is created - same as any other type of index.
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]
