json_quote

Description

Syntax

VARCHAR json_quote(VARCHAR)

Enclose json_value in double quotes (“), escape special characters contained.

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. +------------------------+

keyword

json_quote