QUOTE()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Xpand
Topics on this page:
Overview
Returns a string that is enclosed in single quotes with properly escaped special characters.
USAGE
QUOTE(string)
Argument Name | Description |
|---|---|
| The string to quote |
DETAILS
QUOTE() is a string function that returns a string enclosed with single quotation marks and properly escaped special characters.
The return value uses backslash escapes to handle both single quotes and backslash characters that may exist in the source string.
For the reverse operation, see UNQUOTE().
A NULL is returned if the argument is NULL.
EXAMPLES
SELECT QUOTE(SPACE(3));
+-----------------+
| QUOTE(SPACE(3)) |
+-----------------+
| ' ' |
+-----------------+
SELECT QUOTE("it's");
+---------------+
| QUOTE("it's") |
+---------------+
| 'it\'s' |
+---------------+