Why does the full-text string search "FDR" not return results in MySQL?

I am trying to do a user search based on full-text search.

SELECT * FROM users WHERE MATCH (name) AGAINST ('FDR' in BOOLEAN MODE);

However, the query yields no results. I can replace the search value with other lines and give results.

I even tried using a null list of words without success. The problem is with this particular line.

+3
source share
2 answers

From dev.mysql.com/doc/refman/5.1/en/fulltext-fine-tuning.html

- ; . , FULLTEXT.

, , ft_min_word_len ft_max_word_len .

.

+6

- , , MySQL <= 3 .

+4

Source: https://habr.com/ru/post/1703379/


All Articles