Mega Code Archive

 

Categories / MySQL / Regular Expression

 

Matches where a is the first character

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