SQL Tutorial SQL Advanced SQL Database SQL References

MySQL QUOTE() Function



The MySQL QUOTE() function produces 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

QUOTE(str)

Parameters

str Required. Specify a string.

Return Value

Returns a string that can be used as a properly escaped data value in an SQL statement.

Example 1:

The example below shows the usage of QUOTE() function.

mysql> SELECT QUOTE('Don\'t!');
Result: 'Don\'t!'

mysql> SELECT QUOTE(NULL);
Result: 'NULL'

mysql> SELECT QUOTE('Don\'t! Do it');
Result: 'Don\'t! Do it'

❮ MySQL Functions