JSON_QUOTE

Description

Returns the string as a JSON value, wrapped in double quotation marks and with internal quotation marks and other characters escaped. The result is returned as a utf8mb4 string.

This function is typically used to generate valid JSON string literals for inclusion in JSON documents, making it easier to process the data.

Syntax

JSON_QUOTE(string)

Description

string is the string to quote. If the argument is NULL, NULL is returned.

Examples

SELECT JSON_QUOTE('null'), JSON_QUOTE('"null"');
+--------------------+----------------------+
| JSON_QUOTE('null') | JSON_QUOTE('"null"') |
+--------------------+----------------------+
| "null"             | "\"null\""           |
+--------------------+----------------------+
1 row in set (0.001 sec)

SELECT JSON_QUOTE('[1, 2, 3, 4, 5]');
+-------------------------------+
| JSON_QUOTE('[1, 2, 3, 4, 5]') |
+-------------------------------+
| "[1, 2, 3, 4, 5]"             |
+-------------------------------+
1 row in set (0.001 sec)

SELECT JSON_QUOTE('{"name":sam, "scores":[100,200,300]}');
+----------------------------------------------------+
| JSON_QUOTE('{"name":sam, "scores":[100,200,300]}') |
+----------------------------------------------------+
| "{\"name\":sam, \"scores\":[100,200,300]}"         |
+----------------------------------------------------+
1 row in set (0.001 sec)