Pattern Matching with Regular Expressions : Patterns « Regular Expression « SQL / MySQL






  1. SQL / MySQL
  2. Regular Expression
  3. Patterns

Pattern Matching with Regular Expressions

       

Pattern                What the pattern matches
^                      Beginning of string
$                      End of string
.                      Any single character
[...]                  Any character listed between the square brackets
[^...]                 Any character not listed between the square brackets
p1|p2|p3               Alternation; matches any of the patterns p1, p2, or p3
*                      Zero or more instances of preceding element
+                      One or more instances of preceding element
{n}                    n instances of preceding element
{m,n}                  m through n instances of preceding element








Related examples in the same category

1.Pattern match: string has 5 characters
2.Pattern match: letter repeats
3.Pattern in Where clause
4.Using Pattern Matching
5.Pattern Matching
6.Show records where the name matches a search pattern
7.Matching Pattern Metacharacters Literally
8.To match a literal instance of a SQL pattern metacharacter, precede it with a backslash:
9.To make a pattern match case sensitive, use a binary string for either operand