只需在角色前使用反斜杠,如

MySQL documentation section 9.1所示：

\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.

注意(来自MySQL文档)：

If you use “\%” or “\_” outside of pattern-matching contexts, they evaluate to the strings “\%” and “\_”, not to “%” and “_”.