[mysqld]

innodb_ft_min_token_size=1

innodb_ft_enable_stopword = OFF

init-connect='SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci'

collation-server = utf8mb4_unicode_ci

[client]

default-character-set=utf8mb4

[mysql]

default-character-set=utf8mb4

create database test;

use test;

create table `test` (`id` bigint(20) not null auto_increment, `text` text character set utf8mb4 collate utf8mb4_unicode_ci default null, primary key (`id`), fulltext key `ftidx` (`text`)) default charset=utf8mb4 collate=utf8mb4_unicode_ci;

insert into `test` (`text`) values ('a 哈 😂 🐧');

MariaDB [test]> select * from test where text like "%😂%";

+----+-----------------+

| id | text            |

+----+-----------------+

|  1 | a 哈 😂 🐧        |

+----+-----------------+

1 row in set (0.001 sec)

MariaDB [test]> select * from test where match text against ("a");

+----+-----------------+

| id | text            |

+----+-----------------+

|  1 | a 哈 😂 🐧        |

+----+-----------------+

1 row in set (0.001 sec)

MariaDB [test]> select * from test where match text against ("哈");

+----+-----------------+

| id | text            |

+----+-----------------+

|  1 | a 哈 😂 🐧        |

+----+-----------------+

1 row in set (0.001 sec)

MariaDB [test]> select * from test where match text against ("😂");

Empty set (0.001 sec)