mysql - AWS RDS MySQL FullText Index with 2 Character Words

Question

I want to Query my Database Table with an FullText Index and it should consider 2 character words too.

I have an AWS RDS MySQL Database (Engine version 8.0.17). I have an FullText Index on my Table which works fine. But only consider words with minimum 3 character.

i already searched in the web, and found that i have to adjust the "ft_min_word_len" variable. The strange thing, the original value of ft_min_word_len was 4. But the index already worked with 3 characters too.

Now i adjusted the ft_min_word_len to 2 via RDS Parameter Group Restarted the database. Deleted and Recreated the FullText Index, but no change.

But still: Only 3 character Words are considerred. if i haven an entry with: "114 Apple"

This select found the entry:

select * from TestTable where MATCH (title) AGAINST('114' IN BOOLEAN MODE)

if i have an entry with "11 Apple" The corresponding select

select * from TestTable where MATCH (title) AGAINST('11' IN BOOLEAN MODE) doesn't find an entry.

The Query:

show variables where variable_name = 'ft_min_word_len';

shows the correct new value 2

Does anyone have an idea?

Kind Regards

标签： mysqlfull-text-searchamazon-rdsfulltext-index