add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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"