MariaDB [test]> select json_extract('{"a": { "b": "1234" }}', '$.a');
|
+-----------------------------------------------+
|
| json_extract('{"a": { "b": "1234" }}', '$.a') |
|
+-----------------------------------------------+
|
| {"b": "1234"} |
|
+-----------------------------------------------+
|
1 row in set (0.000 sec)
|
|
MariaDB [test]> select json_compact(json_extract('{"a": { "b": "1234" }}', '$.a'));
|
+-------------------------------------------------------------+
|
| json_compact(json_extract('{"a": { "b": "1234" }}', '$.a')) |
|
+-------------------------------------------------------------+
|
| {"b":"1234"} |
|
+-------------------------------------------------------------+
|
1 row in set (0.000 sec)
|
|
MariaDB [test]> select json_unquote(json_compact(json_extract('{"a": { "b": "1234" }}', '$.a')));
|
+---------------------------------------------------------------------------+
|
| json_unquote(json_compact(json_extract('{"a": { "b": "1234" }}', '$.a'))) |
|
+---------------------------------------------------------------------------+
|
| {"b": "1234"} |
|
+---------------------------------------------------------------------------+
|
1 row in set (0.000 sec)
|