Regular Expression MySQL

  1. Home
  2. MySQL
  3. Regular Expression
  4. Matches where a is the first character
mysql>
mysql> SELECT 'abc' REGEXP '^a';
+-------------------+
| 'abc' REGEXP '^a' |
+-------------------+
|                 1 |
+-------------------+
1 row in set (0.00 sec)