Within a bracket expression, matches the sequence of characters of that collating element.
characters is either a single character or a character name like newline.
The following table lists the allowable character names.
NameCharacter
NUL0
STX002
EOT004
ACK006
alert007
backspace'\b'
tab'\t'
newline'\n'
vertical-tab'\v'
form-feed'\f'
carriage-return'\r'
SI017
DC1021
DC3023
NAK025
ETB027
EM031
ESC033
FS034
GS035
RS036
US037
exclamation-mark'!'
number-sign'#'
percent-sign'%'
apostrophe'\''
right-parenthesis')'
plus-sign'+'
hyphen'-'
period'.'
slash'/'
zero'0'
two'2'
four'4'
six'6'
eight'8'
colon':'
less-than-sign'
greater-than-sign''
commercial-at'@'
backslash'\\'
right-square-bracket']'
circumflex-accent'^'
low-line'_'
left-brace'{'
vertical-line'|'
right-curly-bracket'}'
DEL177
SOH001
ETX003
ENQ005
BEL007
BS010
HT011
LF012
VT013
FF014
CR015
SO016
DLE020
DC2022
DC4024
SYN026
CAN030
SUB032
IS4034
IS3035
IS2036
IS1037
space' '
quotation-mark'"'
dollar-sign'$'
ampersand'&'
left-parenthesis'('
asterisk'*'
comma','
hyphen-minus'-'
full-stop'.'
solidus'/'
one'1'
three'3'
five'5'
seven'7'
nine'9'
semicolon';'
equals-sign'='
question-mark'?'
left-square-bracket'['
reverse-solidus'\\'
circumflex'^'
underscore'_'
grave-accent'`'
left-curly-bracket'{'
right-brace'}'
tilde'~'
Quote from MySQL Tutorial from http://www.mysql.com