QUOTE( 値 )
QUOTE関数を使用することで、数値や文字列などの値をシングルクオートで囲み特殊文字をエスケープすることができます。
mysql> SELECT QUOTE( 2 ); +------------+ | QUOTE( 2 ) | +------------+ | '2' | +------------+ 1 row in set (0.00 sec) mysql> SELECT QUOTE( -3.1415 ); +------------------+ | QUOTE( -3.1415 ) | +------------------+ | '-3.1415' | +------------------+ 1 row in set (0.02 sec)
mysql> SELECT QUOTE( 'ABC' ); +----------------+ | QUOTE( 'ABC' ) | +----------------+ | 'ABC' | +----------------+ 1 row in set (0.00 sec)
mysql> SET @TEST = "I'll be back!"; Query OK, 0 rows affected (0.00 sec) mysql> SELECT @TEST; +---------------+ | @TEST | +---------------+ | I'll be back! | +---------------+ 1 row in set (0.00 sec) mysql> SELECT QUOTE( @TEST ); +------------------+ | QUOTE( @TEST ) | +------------------+ | 'I\'ll be back!' | +------------------+ 1 row in set (0.00 sec)
mysql> SET @TEST = "\\1,000"; Query OK, 0 rows affected (0.00 sec) mysql> SELECT @TEST; +--------+ | @TEST | +--------+ | \1,000 | +--------+ 1 row in set (0.00 sec) mysql> SELECT QUOTE( @TEST ); +----------------+ | QUOTE( @TEST ) | +----------------+ | '\\1,000' | +----------------+ 1 row in set (0.00 sec)
引数がNULLの場合はNULLがそのまま返されます。
mysql> SELECT QUOTE( NULL ); +---------------+ | QUOTE( NULL ) | +---------------+ | NULL | +---------------+ 1 row in set (0.00 sec)
QUOTE | 値をシングルクオートで囲み特殊文字をエスケープする |