JSON_QUOTE

Syntax

JSON_QUOTE(json_value)

Description

Quotes a string as a JSON value, usually for producing valid JSON string literals for inclusion in JSON documents. Wraps the string with double quote characters and escapes interior quotes and other special characters, returning a utf8mb4 string.

Returns NULL if the argument is NULL.

Examples

SELECT JSON_QUOTE('A'), JSON_QUOTE("B"), JSON_QUOTE('"C"'); +-----------------+-----------------+-------------------+ | JSON_QUOTE('A') | JSON_QUOTE("B") | JSON_QUOTE('"C"') | +-----------------+-----------------+-------------------+ | "A" | "B" | "\"C\"" | +-----------------+-----------------+-------------------+

_{This page is licensed: CC BY-SA / Gnu FDL}