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 | +-------------+