General MySQL Oracle SQL Server

QUOTE() - MySQL Quoting String

Q

How to escape quotes in string to be used in MySQL statements using the QUOTE() function?

✍: FYIcenter.com

A

QUOTE(str) is a MySQL built-in function that escapes quotes in a given string to be used in MySQL statements. For example: 

SELECT QUOTE("It's 5 o'clock!");
  -- +--------------------------+
  -- | QUOTE("It's 5 o'clock!") |
  -- +--------------------------+
  -- | 'It\'s 5 o\'clock!'      |
  -- +--------------------------+

Reference information of the QUOTE() function: 

QUOTE(str): modstr
  Escapes the sting str with each instance of backslash (\), single
  quote ('), ASCII NUL, and Control+Z preceded by a backslash.

Arguments, return value and availability:
  str: Required. The given string to be escaped
  modstr: Return value. The escaped string.
  Available since MySQL 5.7.

 

⇒ REPEAT() - Repeating String

⇐ POSITION() - Synonym for LOCATE()

⇑ MySQL Functions on Character String Values

⇑⇑ MySQL Function References

2023-11-13, 1406🔥, 0💬

General MySQL Oracle SQL Server