Escape codes (MySQL)

\0 	An ASCII NUL (0x00) 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

Bronnen

• https://dev.mysql.com/doc/refman/5.0/en/string-literals.html