The FULLTEXT key search is faster than the usual LIKE search, but its use is limited by the number of characters in the search word. Full text indexes are supported by MyISAM tables. Innodb support has been added since version 5.6.4.
Check the number of characters you are looking for :
SHOW VARIABLES LIKE ' ft_min_word_len '
Set the required quantity :
In the config file /etc/mysql/my.cnf (it may differ for different OS)
[mysqld]
ft_min_word_len=3
Restart mysql (mysqld or mariadb):
sudo service mysql restart
It is advisable to reset the cache of the table that will be searched:
REPAIR TABLE table QUICK;
FLUSH table table;
Adding a FULLTEXT key:
ALTER TABLE ` table ` ADD FULLTEXT(` field `);
Now the search for three or more characters will work without difficulty :
SELECT * FROM table
WHERE MATCH ( field ) AGAINST (' +Пик ' IN BOOLEAN MODE);