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

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'