Changes

Jump to: navigation, search

MySQL Regular Expression Searches

187 bytes added, 18:49, 19 October 2007
Matching by Character Type
<td><nowiki>[[:alnum:]]</nowiki><td>Alphanumeric - any number or letter. Equivalent to [a-z], [A-Z] and [0-9]</td>
<tr>
<td><nowiki>[[:alpha:]]</nowiki><td>Alpha - any letter. Equivalent to [a-z] and [A-Z]</td>
<tr>
<td><nowiki>[[:blank:]]</nowiki><td>Space or Tab. Equivalent to [\\t] and [ ]</td>
<tr>
<td><nowiki>[[:cntrl:]]</nowiki><td>ASCII Control Character</td>
<tr>
<td><nowiki>[[:digit:]]</nowiki><td>Numeric. Equivalent to [0-9]</td>
<tr>
<td><nowiki>[[:graph:]]</nowiki><td>Any character with the exception of space</td>
<tr>
<td><nowiki>[[:lower:]]</nowiki><td>Lower case letters. Equivalent to [a-z]</td>
<tr>
<td><nowiki>[[:print:]]</nowiki></nowiki><td>Any printable character</td>
<tr>
<td><nowiki>[[:punct:]]</nowiki><td>Characters that are neither control characters, nor alphanumeric (i.e punctuation characters)</td>
<tr>
<td><nowiki>[[:space:]]</nowiki><td>Any whitespace character (tab, new line, form feed, space etc)</td>
<tr>
<td><nowiki>[[:upper:]]</nowiki><td>Upper case letters. Equivalent to [A-Z]</td>
<tr>
<td><nowiki>[[:xdigit:]]</nowiki><td>Any hexadecimal digit. Equivalent to [A-F], [a-f] and [0-9]
</table>

Navigation menu