Description

The QUOTE( ) function returns a string to produce a result, which can be used as a properly escaped date value in the SQL statement. If the argument is NULL, then the return value is NULL.

This function has the form:

SELECT QUOTE(str)

Parameter	Description
str	A string

Return Value

A string to produce a result, which can be used as a properly escaped date value in the SQL statement. If the argument is NULL, then the return value is NULL.

Examples

The following example shows the basic use of this function:

mysql> SELECT QUOTE('Don\'t!');
-> 'Don\'t!'
mysql> SELECT QUOTE(NULL);
-> NULL