Mega Code Archive

 

Categories / MySQL / Data Type

 

Writing Strings That Include Quotes or Special Characters

mysql> mysql> mysql> SELECT "I'm asleep"; +------------+ | I'm asleep | +------------+ | I'm asleep | +------------+ 1 row in set (0.00 sec) mysql> mysql> SELECT 'He said, "Boo!"'; +-----------------+ | He said, "Boo!" | +-----------------+ | He said, "Boo!" | +-----------------+ 1 row in set (0.00 sec)