MaxInterview - how to use wildcard in jason value

showing results for - "how to use wildcard in jason value"

1select json_value(t.trans_msg, '$.CheckDetails[0].CheckNumber'), -- works returns 101
2       json_value(t.trans_msg, '$.CheckDetails[*].CheckNumber'), -- null returned      
3       json_value(t.trans_msg, '$.CheckDetails[0,1].CheckNumber') -- null returned      
4 from transactions t
5where t.id = 1 
6

1SELECT JSON_VALUE(@json,'$.Dims[0].Name');
2

similar questions

json schema verify 2fajv mysql get json value by key json fetch data doest show get value from serialized json apex json array in hidden field not coming how to print json stringify of nested objects json schema validator allows null json formet data jquery search in json get json data joi object id validation getobject returning exact value instead of json object displaying json data in chartjs json data check use get json in jstree example storing jason format in perl and retriving it rails json schema validation json schema enumerated type json decoding and optionals response 28 29 3ejson 28 5b 27data 27 3d 3e 24allcheaters 5d 29 not getting back

queries leading to this page

how to use wildcard in jason value how to use wildcard in jason value