Searching within json array does not work as expected

General Discussions - English
1

CREATE TABLE test (
id bigint,
data json
);
insert into test values(5,‘{“ut”:[“abc”,“qwe”,“zxc”]}’);
select * from test;
±-----±---------------------------+
| id | data |
±-----±---------------------------+
| 5 | {“ut”:[“abc”,“qwe”,“zxc”]} |
±-----±---------------------------+

MySQL [(none)]> select * from test where data.ut in (‘abc’);
Empty set (0.000 sec)

Why it does not work?

2

Try this syntax Manticore Search Manual: Functions > Arrays and conditions functions