mysql json 数组查询

select bundle_config from app_resource where valid=1 andapp_name='appkey01' limit 1;-- select * from log2 where JSON_CONTAINS(data,JSON_OBJECT('id', "142"))select * from app_patch where va...

红枫斋

4623人浏览 · 2021-02-05 17:42:00

红枫斋 · 2021-02-05 17:42:00 发布

select bundle_config from app_resource where valid=1 and  app_name='appkey01' limit 1;

-- select * from log2 where JSON_CONTAINS(data,JSON_OBJECT('id', "142"))

select * from app_patch where valid=1 and
JSON_CONTAINS(batch_content,JSON_OBJECT('dimType',2))
and JSON_CONTAINS(batch_content,JSON_OBJECT('dimId',111));



select * from app_patch where valid=1
and JSON_CONTAINS(test,JSON_ARRAY(111,333));

select * from app_patch where valid=1 and
JSON_CONTAINS(test,JSON_OBJECT('dimType',2))
and JSON_CONTAINS(test,JSON_OBJECT('dimId',111))