mysql> select name from alternames where match(name) against ('Москв* IN BOOLEAN MODE'); +------------------+ | name | +------------------+ | Mode | | Mode | | Mode | | Modu Mode | | Île Saint-Modé | | Kozos Mode | +------------------+ 6 rows in set (0.00 sec) mysql> select name from alternames where match(name) against ('Москва* IN BOOLEAND MODE'); +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | name | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Mode | | Mode | | Mode | | Modu Mode | | Kozos Mode | | Île Saint-Modé | | Москва | | Москва | | Москва | | Москва | | Москва | | Москва | | МОСКВА | | Москва | | Москва | | Новая Москва | | Банка Москва | | Менеуз-Москва | +----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+