Syntax\n------\n\nJSON_UNQUOTE(val)\n\nDescription\n-----------\n\nUnquotes a JSON value, returning a string, or NULL if the argument is null.\n\nAn error will occur if the given value begins and ends with double quotes and is an invalid JSON string literal.\n\nIf the given value is not a JSON string, value is passed through unmodified.\n\nCertain character sequences have special meanings within a string. Usually, a backslash is ignored, but the escape sequences in the table below are recognised by MariaDB, unless the SQL Mode is set to NO_BACKSLASH_ESCAPES .\n\n| Escape sequence | Character                          |\n| --------------- | ---------------------------------- |\n| "               | Double quote (")                   |\n| \\b              | Backslash                          |\n| \\f              | Formfeed                           |\n| \\n              | Newline (linefeed)                 |\n| \\r              | Carriage return                    |\n| \\t              | Tab                                |\n| \\\\              | Backslash ()                       |\n| \\uXXXX          | UTF-8 bytes for Unicode value XXXX |\n\nExamples\n--------\n\nSELECT JSON_UNQUOTE('"Monty"');\n+-------------------------+\n| JSON_UNQUOTE('"Monty"') |\n+-------------------------+\n| Monty                   |\n+-------------------------+\n\nURL: https://mariadb.com/docs/server/reference/sql-functions/special-functions/json-functions/json_unquote