QUOTE(str)

MySQL 8.4

Quotes a string to produce a result that can be used as a properly escaped data value in an SQL statement. The string is returned enclosed by single quotation marks and with each instance of backslash (\), single quote ('), ASCII NUL, and Control+Z preceded by a backslash. If the argument is NULL, the return value is the word “NULL” without enclosing single quotation marks.

Syntax

MYSQL

SELECT QUOTE('Don\'t!');
'Don\'t!'
SELECT QUOTE(NULL);
NULL

Examples

Example

For comparison, see the quoting rules for literal strings and within the C API in Section 11.1.1, “String Literals”, and mysql_real_escape_string_quote().

MYSQL

SELECT QUOTE('Don\'t!');
'Don\'t!'
SELECT QUOTE(NULL);
NULL