MariaDB starting with 10.2.4
This function was added in MariaDB 10.2.4.
JSON_COMPACT(json_doc)
Removes all unnecessary spaces so the json document is as short as possible.
SET @j = '{ "A": 1, "B": [2, 3]}';
SELECT JSON_COMPACT(@j), @j;
+-------------------+------------------------+
| JSON_COMPACT(@j) | @j |
+-------------------+------------------------+
| {"A":1,"B":[2,3]} | { "A": 1, "B": [2, 3]} |
+-------------------+------------------------+
- JSON video tutorial covering JSON_COMPACT.