Mega Code Archive

 

Categories / MySQL / Data Type

 

To include a quote character within a string that is quoted by the same kind of quote

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