Mega Code Archive

 
Categories / MySQL Tutorial / Regular Expressions
 

[ characters ]

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