QUOTE
Quotes a string to produce a result that can be used as a properly escaped data value in an SQL statement.
Analyze Syntax
func.quote(<str>)
Analyze Examples
func.quote('Don\'t')
+----------------------+
| func.quote('Don\'t') |
+----------------------+
| Don\'t! |
+----------------------+
SQL Syntax
QUOTE(<str>)
SQL Examples
SELECT QUOTE('Don\'t!');
+-----------------+
| QUOTE('Don't!') |
+-----------------+
| Don\'t! |
+-----------------+
SELECT QUOTE(NULL);
+-------------+
| QUOTE(NULL) |
+-------------+
| NULL |
+-------------+
Last modified April 01, 2024 at 11:19 AM EST: wip (1bb56e9)