Топ-100
 

QUOTE

База данных: MySQL
Текст

Syntax:
QUOTE(str)

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.

URL: https://dev.mysql.com/doc/refman/8.0/en/string-functions.html

Пример

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