First time here? Check out the FAQ!
Ask Your Question

Revision history  [back]

Revision 3
Evgeny's avatar
13.2k
Evgeny
updated 2010-10-14 20:26:42 -0600

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.

Revision 2
Evgeny's avatar
13.2k
Evgeny
updated 2010-10-14 20:22:19 -0600

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.

Revision 1
Benoit's avatar
875
Benoit
answered 2010-10-13 07:16:53 -0600

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.