By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
VERSION() |
---|
8.0.12 |
JSON_SEARCH(@`json`, 'one', 'AB') |
---|
"$[2].C" |
JSON_SEARCH('["A", [{"B": "1"}], {"C": "AB"}, {"D": "BC"}]', 'one', 'AB') |
---|
"$[2].C" |
JSON_SEARCH('["A", [{"B": "1"}], {"C": "AB"}, {"D": "BC"}]', 'one', @`value`) |
---|
"$[2].C" |
JSON_SEARCH(@`json`, 'one', 'AB') |
---|
"$[2].C" |
JSON_SEARCH(@`json`, 'one', @`value`) |
---|
"$[2].C" |
JSON_SEARCH(JSON_UNQUOTE(@`json`), 'one', @`value`) |
---|
"$[2].C" |