2

I'm using this search

-> match (c1, c2) against (">dg*" in boolean mode);

and I get this list

1 dgas

2 dgica

3 dgicb

4 dgii

5 dgit

6 dgly

7 dgc

8 dgse

which seems reasonable.

The problem is that I DON'T get "dgl", which I know is there in column c1.

So I DO get "dgly" but NOT "dgl".

I find this confusing and would appreciate any thoughts. Thanks.

adamD
  • 125
  • 2

1 Answers1

3

MySQL fulltext indexing will, by default, ignore words that are shorter than four characters.

This can be changed at the server level by setting ft_min_word_len to a smaller number and then rebuilding the fulltext indexes.

Here's more information in the manual about fine-tuning fulltext searches.

Charles
  • 50,943
  • 13
  • 104
  • 142