First time here? Check out the FAQ!

Revision history  [back]

Turns out that MySQL can be tuned to do a FULLTEXT search on smaller than 4 characters. Here are the steps:

  • Edit the mysql config file (mine was /etc/my.cnf)

In the [mysqld] section, add the line:

ft_min_word_len=3

Restart mysql server and rebuild the FULLTEXT index on the answer, question and tags tables:

REPAIR TABLE answer QUICK;
REPAIR TABLE question QUICK;
REPAIR TABLE tag QUICK;

At this point, the search will return 3 letter words.

Turns out that MySQL can be tuned to do a FULLTEXT FULLTEXT search on smaller than 4 characters. Here are the steps:

  • Edit the mysql config file (mine was /etc/my.cnf)

In the [mysqld] section, add the line:

ft_min_word_len=3

  • Restart mysql server and rebuild server
  • Rebuild the FULLTEXT FULLTEXT index on the the answer, question and tags tables:

    REPAIR TABLE answer QUICK; REPAIR TABLE question QUICK; REPAIR TABLE tag QUICK;

    QUICK;

At this point, the search will return 3 letter words.

Turns out that MySQL can be tuned to do a FULLTEXT search on smaller than 4 characters. Here are the steps:

  • Edit the mysql config file (mine was /etc/my.cnf)
/etc/my.cnf)

In the [mysqld] section, add the line:

ft_min_word_len=3
ft_min_word_len=3
  • Restart mysql server
  • Rebuild the FULLTEXT index on the answer, answer and question and tags tables:

    REPAIR TABLE answer QUICK;

    REPAIR TABLE answer QUICK; REPAIR TABLE question QUICK; REPAIR TABLE tag QUICK;

At this point, the search will return 3 letter words.