Matches where a is the first character : Begin With « Regular Expression « SQL / MySQL






  1. SQL / MySQL
  2. Regular Expression
  3. Begin With

Matches where a is the first character

      
mysql>
mysql> SELECT 'abc' REGEXP '^a';
+-------------------+
| 'abc' REGEXP '^a' |
+-------------------+
|                 1 |
+-------------------+
1 row in set (0.00 sec)








Related examples in the same category

1.The caret (^) anchors the start, and the dollar sign ($) the end;
2.Pattern Matching: beginning with 'b'
3.String begins with
4.Pattern match: string begin with a certain letter
5.Pattern match: string begin and end
6.Show records where the name begins with a "B"
7.Show records where the name begins with a "B" or "C"
8.Strings that begin with a particular substring:
9.Matches strings that begin with a vowel or end with er: