MySQL recognizes the following escape sequences. : String « Data Types « MySQL Tutorial

\0	An ASCII 0 (NUL) character.
\'	A single quote (') character.
\"	A double quote (") character.
\b	A backspace character.
\n	A newline (linefeed) character.
\r	A carriage return character.
\t	A tab character.
\Z	ASCII 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>
mysql> SELECT 'This\nIs\nFour\nLines';
+--------------------+
| This
Is
Four
Lines |
+--------------------+
| This
Is
Four
Lines |
+--------------------+
1 row in set (0.00 sec)

mysql>
mysql>

10.21.String
	10.21.1.	Character or String Data Types
	10.21.2.	Strings
	10.21.3.	MySQL recognizes the following escape sequences.
	10.21.4.	To include quote characters within a string
	10.21.5.	A " inside a string quoted with " may be written as "".
	10.21.6.	Precede the quote character by an escape character (\).
	10.21.7.	A single quotation inside a string quoted with double quotation needs no special treatment.
	10.21.8.	A double quotation inside a string quoted with single quotation needs no special treatment.
	10.21.9.	When inserting binary data into a string column (such as a BLOB column), the following characters must be represented by escape sequences:
	10.21.10.	Hexadecimal Values
	10.21.11.	String comparisons normally are case-insensitive