json_quote

description

Syntax

VARCHAR json_quote(VARCHAR)

将json_value用双引号（”）括起来，跳过其中包含的特殊转义字符

example

1. MySQL> SELECT json_quote('null'), json_quote('"null"');
2. +--------------------+----------------------+
3. | json_quote('null') | json_quote('"null"') |
4. +--------------------+----------------------+
5. | "null"             | "\"null\""           |
6. +--------------------+----------------------+

9. MySQL> SELECT json_quote('[1, 2, 3]');
10. +-------------------------+
11. | json_quote('[1, 2, 3]') |
12. +-------------------------+
13. | "[1, 2, 3]"             |
14. +-------------------------+

17. MySQL> SELECT json_quote(null);
18. +------------------+
19. | json_quote(null) |
20. +------------------+
21. | NULL             |
22. +------------------+

24. MySQL> select json_quote("\n\b\r\t");
25. +------------------------+
26. | json_quote('\n\b\r\t') |
27. +------------------------+
28. | "\n\b\r\t"             |
29. +------------------------+

keywords

json,quote,json_quote