Collections:
JSON_QUOTE() - Quoting JSON String
How to convert a regular character string into a JSON (JavaScript Object Notation) string using the JSON_QUOTE() function?
✍: FYIcenter.com
JSON_QUOTE(str) is a MySQL built-in function that converts a regular character string into a JSON string by quoting the string with double quotes. It replaces the double-quote character (") as (\") within the string, and the escape character (\) as (\\). For example:
SELECT JSON_QUOTE('null'), JSON_QUOTE('"null"'); -- +--------------------+----------------------+ -- | JSON_QUOTE('null') | JSON_QUOTE('"null"') | -- +--------------------+----------------------+ -- | "null" | "\"null\"" | -- +--------------------+----------------------+
JSON uses the backslash "\" as the escape character. And "\" itself needs to be quoted. But "\" is also the escape character for MySQL string literals. So entering a "\" into a JSON string in MySQL statement becomes very tricky as shown below:
SELECT JSON_QUOTE('C:\Windows'), JSON_QUOTE('C:\\Windows'); -- +--------------------------+---------------------------+ -- | JSON_QUOTE('C:\Windows') | JSON_QUOTE('C:\\Windows') | -- +--------------------------+---------------------------+ -- | "C:Windows" | "C:\\Windows" | -- +--------------------------+---------------------------+ SELECT JSON_QUOTE('Next\nLine'), JSON_QUOTE('Next\\nLine');; -- +--------------------------+---------------------------+ -- | JSON_QUOTE('Next\nLine') | JSON_QUOTE('Next\\nLine') | -- +--------------------------+---------------------------+ -- | "Next\nLine" | "Next\\nLine" | -- +--------------------------+---------------------------+
Reference information of the JSON_QUOTE() function:
JSON_QUOTE(str): json Returns a JSON quoted string converted from a given MySQL character string. Arguments, return value and availability: str: Required. The character string be quoted. json: Return value. The quoted JSON string value. Available since MySQL 5.7.
⇒ JSON_REMOVE() - Removing JSON Child Members
⇐ JSON_PRETTY() - Validating JSON Value
2023-12-10, 319🔥, 0💬
Popular Posts:
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...