mysql json

SELECT distinct CAST(JSON_UNQUOTE(attributes_json->’$.ClusterI{D}^{\prime })ASchar)asoidFROM‘t_{c}able‘whereattribute{s}_{j}son-{>}^{\prime }$.ClusterID’ > ‘0307000074’;
#select * from t_cable c where [project_code]=‘TOMSerbia’;

SELECT distinct json_keys(attributes_json) as “keys” FROM t_cable;

SELECT distinct CAST(JSON_UNQUOTE(attributes_json->’$.ClusterI{D}^{\prime })ASchar)asoidFROM‘t_{c}able‘;SELECTdistinctCAST(JSO{N}_{U}NQUOTE(attribute{s}_{j}son-{>}^{\prime }$.ClusterID’) AS char) as oid FROM t_cable where attributes_json->’$.ClusterID’ > ‘0307000074’;

select * from t_cable where attributes_json->’$.EndI{D}^{\prime }{=}^{\prime }0201000054^{\prime }andattribute{s}_{j}son-{>}^{\prime }$.ClusterID’ >= ‘0307000064’;
select * from t_cable where attributes_json->’$.EndI{D}^{\prime }{=}^{\prime }0201000054^{\prime }andattribute{s}_{j}son-{>}^{\prime }$.ClusterID’ >= ‘0307000064’;

SELECT COUNT(0) FROM t_cable WHERE project_code=‘TOMSerbia’ and attributes_json->’$.EndI{D}^{\prime }{=}^{\prime }0201000054^{\prime }andattribute{s}_{j}son-{>}^{\prime }$.ClusterID’>=‘0307000064’;

SELECT distinct CAST(JSON_UNQUOTE(attributes_json->’$.ClusterI{D}^{\prime })ASchar)asoidFROM‘t_{c}able‘;SELECTcount(distinctCAST(JSO{N}_{U}NQUOTE(attribute{s}_{j}son-{>}^{\prime }$.ClusterID’) AS char)) as c FROM t_cable where attributes_json->’$.ClusterI{D}^{\prime };SELECTcount(distinctJSO{N}_{U}NQUOTE(attribute{s}_{j}son-{>}^{\prime }$.ClusterID’)) as c FROM t_cable where attributes_json->’$.ClusterID’;