Changes

Jump to: navigation, search

MySQL Regular Expression Searches

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

Navigation menu