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, 442🔥, 0💬
Popular Posts:
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...