add batch remove batch split batch show hidden batches hide batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
version()
10.4.7-MariaDB-1:10.4.7+maria~buster
data
{"foo": "bar"}
data
{"foo": "bar"}
data
"bar"
data
"bar"
json_extract('"bar"', '$')
"bar"
json_unquote(json_extract('"bar"', '$'))
bar
json_extract('{"foo": "bar"}', '$.foo')
"bar"
json_unquote(json_extract('{"foo": "bar"}', '$.foo'))
bar
json_extract('{"foo": "bar"}', '$.foo') = json_extract('{"foo": "bar"}', '$.foo')
0
json_unquote(json_extract('{"foo": "bar"}', '$.foo')) = json_unquote(json_extract('{"foo": "bar"}', '$.foo'))
1
json_extract('{"foo": "bar"}', '$.foo') = json_unquote(json_extract('{"foo": "bar"}', '$.foo'))
0
json_unquote(json_extract('{"foo": "bar"}', '$.foo')) = json_extract('{"foo": "bar"}', '$.foo')
0
json_extract('{"foo": "bar"}', '$.foo') = json_unquote(json_extract('"bar"', '$'))
0
data
{"foo": "bar"}