MariaDB starting with 10.2.4
This function was added in MariaDB 10.2.4.
JSON_DETAILED(json_doc[, tab_size])
Represents JSON in the most understandable way emphasizing nested structures.
SET @j = '{ "A":1,"B":[2,3]}';
SELECT @j;
+--------------------+
| @j |
+--------------------+
| { "A":1,"B":[2,3]} |
+--------------------+
SELECT JSON_DETAILED(@j);
+------------------------------------------------------------+
| JSON_DETAILED(@j) |
+------------------------------------------------------------+
| {
"A": 1,
"B":
[
2,
3
]
} |
+------------------------------------------------------------+
- JSON video tutorial covering JSON_DETAILED.