----------+ | \r | Carriage return. | +-----------------------------------------------+-----------------------------+ | \t | Tab. | +-----------------------------------------------+-----------------------------+ | \Z | ASCII 26 (Control+Z). See | | | note following the table. | +-----------------------------------------------+-----------------------------+ | \\ | Backslash ("\"). | +-----------------------------------------------+-----------------------------+ | \% | "%" character. See note | | | following the table. | +-----------------------------------------------+-----------------------------+ | \_ | A "_" character. See note | | | following the table. | +-----------------------------------------------+-----------------------------+ Escaping the % and _ characters can be necessary when using the LIKE operator, which treats them as special characters. The ASCII 26 character (\Z) needs to be escaped when included in a batch file which needs to be executed in Windows. The reason is that ASCII 26, in Windows, is the end of file (EOF). Backslash (\), if not used as an escape character, must always be escaped. When followed by a character that is not in the above table, backslashes will simply be ignored. URL: https://mariadb.com/kb/en/string-literals/https://mariadb.com/kb/en/string-literals/