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