SQL full text search

Question

Why does not this query return any values?:
SELECT * FROM `ready_tasks` WHERE MATCH (`condition`) AGAINST ('12');
I have table with `condition` and there is text `Найти вероятность того, что дни рождения 12 челове...`
`condition` has index with `fulltext`, database has MyISAM

Answer 1

According to this reference, a word having less than 4 characters in length is not indexed, and as such, will be excluded from search results. See "Excluded Results" section.

https://mariadb.com/kb/en/library/full-text-index-overview/

I know this is MariaDB reference, but MySQL & MariaDB shares the same codebase, thus I believe they too share similar behaviour.

Hth, cmiiw