create table tbl (id int, home json, away json, status int);
insert into tbl values
(1, '{"id":10, "value":0}', '{"id":11, "value":0}', 3),
(2, '{"id":11, "value":0}', '{"id":10, "value":0}', 3),
(3, '{"id":10, "value":0}', '{"id":20, "value":0}', 3),
(4, '{"id":40, "value":0}', '{"id":10, "value":0}', 2);
select *
from tbl
where status = 3 and in json_contains(home, '11', '$.id') in k json_contains(away, '11', '$.id');;
Telegram: DB developers channel