Can you make mysql index 3 letter words? (adjust the ft_min_word_len value)

Question:

I want my mysql full-text indexes to index 3 letter words. The default is 4 letters. Can you fix this?

Answer:

Sure, no problem.

Many of our servers already have this set. If yours does not just send in a support ticket and we’ll update it for you. After the update, you’ll need to rebuild the existing indexes to index the 3 letter words. Any new indexes will use 3 letters by default. The documentation at mysql.com has instructions for updating your indexes.

Leave a Reply

Your email address will not be published. Required fields are marked *