Mega Code Archive
MySQL recognizes the following escape sequences
<![CDATA[
\0 An ASCII 0 (NUL) character.
\'A single quote (') character.
\"A double quote (") character.
\bA backspace character.
\nA newline (linefeed) character.
\rA carriage return character.
\tA tab character.
\ZASCII 26 (Control-Z). See note following the table.
\\A backslash (\) character.
\%A '%' character. See note following the table.
\_A '_' character. See note following the table.
mysql>
mysql> SELECT 'This\nIs\nFour\nLines';
+--------------------+
| This
Is
Four
Lines |
+--------------------+
| This
Is
Four
Lines |
+--------------------+
1 row in set (0.00 sec)
mysql>
]]>