{"id":12208,"date":"2023-11-08T23:38:23","date_gmt":"2023-11-09T06:38:23","guid":{"rendered":"https:\/\/www.mysqltutorial.org\/?page_id=12208"},"modified":"2023-11-08T23:38:35","modified_gmt":"2023-11-09T06:38:35","slug":"mysql-json_quote","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-json\/mysql-json_quote\/","title":{"rendered":"MySQL JSON_QUOTE() Function"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the MySQL JSON_QUOTE()<\/code> function to quote a string as a JSON value.<\/p>\n\n\n\n

Introduction to the MySQL JSON_QUOTE() function <\/h2>\n\n\n\n

The JSON_QUOTE()<\/code> function is used to quote a string as a JSON value<\/a> by wrapping it with double quote characters and escaping interior quotes and other characters.<\/p>\n\n\n\n

Here’s the syntax of the JSON_QUOTE()<\/code> function:<\/p>\n\n\n

JSON_QUOTE(string)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this syntax:<\/p>\n\n\n\n
    \n
  • string<\/code>: This is the string that you want to wrap as a JSON value.<\/li>\n<\/ul>\n\n\n\n
    The function returns a valid JSON value of the input string. It’ll return NUL<\/code> if the string is NULL<\/code>.<\/p>\n\n\n\n
    In practice, you often use the JSON_QUOTE()<\/code> function to make a valid JSON string literal for inclusion in a JSON document.<\/p>\n\n\n\n
    MySQL JSON_QUOTE() function examples<\/h2>\n\n\n\n
    Let’s take some examples of using the JSON_QUOTE()<\/code> function.<\/p>\n\n\n\n
    1) Quoting a simple string as a JSON value<\/h3>\n\n\n\n
    The following example uses the JSON_QUOTE() function to wrap a simple string:<\/p>\n\n\n
    SELECT<\/span> JSON_QUOTE('hello'<\/span>);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    Output:<\/p>\n\n\n
    +---------------------+<\/span>\n| JSON_QUOTE('hello') |\n+---------------------+<\/span>\n| \"hello\"             |\n+---------------------+<\/span>\n1 row in set<\/span> (0.01<\/span> sec)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    2) Quoting a string as a JSON array<\/h3>\n\n\n
    SELECT<\/span> JSON_QUOTE('[1,2,3]'<\/span>);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    Output:<\/p>\n\n\n
    +-----------------------+<\/span>\n| JSON_QUOTE('[1,2,3]') |\n+-----------------------+<\/span>\n| \"[1,2,3]\"             |\n+-----------------------+<\/span>\n1 row in set<\/span> (0.00<\/span> sec)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
    Summary<\/h2>\n\n\n\n
      \n
    • Use the JSON_QUOTE()<\/code> function to quote a string as a JSON value.<\/li>\n<\/ul>\n
      \n\t
      \n\t\t
      Was this tutorial helpful? <\/div>\n\t\t
      \n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
      \n\t\t
      \n\t\t\t
      <\/div>\n\t\t\t\n\t\t\t