为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
DM Database Server 64 V8 --03134283914-20220927-170566-20009 Pack3
DB Version: 0x7000c --03134283914-20220927-170566-20009 Pack3
【问题描述】*:
初始数据库字段值:
insert into “T_JSON_VALUE” (“C1”) values (‘{ “bizdata1”:[40,41,42] ,“bizData2”:[941,942,943]}’);
insert into “T_JSON_VALUE” (“C1”) values (‘{ “bizdata1”:[42],“bizData2”:[942,943]}’);
insert into “T_JSON_VALUE” (“C1”) values (‘{ “bizdata1”:[40,41],“bizData2”:[941]}’);
问题:如何查询bizdata1包含41的数据?
1.模拟基础环境
create table T_JSON_VALUE(C1 VARCHAR(1000));
insert into “T_JSON_VALUE” (“C1”) values (‘{ “bizdata1”:[40,41,42] ,“bizData2”:[941,942,943]}’);
insert into “T_JSON_VALUE” (“C1”) values (‘{ “bizdata1”:[42],“bizData2”:[942,943]}’);
insert into “T_JSON_VALUE” (“C1”) values (‘{ “bizdata1”:[40,41],“bizData2”:[941]}’);
commit;
2.查询结果集

3.查询过滤bizdata1包含41的数据

select * from T_JSON_VALUE where C1 @> ‘{ “bizdata1”:[41]}’;