Regular Expressions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Regular Expressions
  4. Match any sequence of zero or more a characters
mysql>
mysql> SELECT 'Ban' REGEXP '^Ba*n';
+----------------------+
| 'Ban' REGEXP '^Ba*n' |
+----------------------+
|                    1 |
+----------------------+
1 row in set (0.00 sec)
mysql>
mysql> SELECT 'Baaan' REGEXP '^Ba*n';
+------------------------+
| 'Baaan' REGEXP '^Ba*n' |
+------------------------+
|                      1 |
+------------------------+
1 row in set (0.00 sec)
mysql>
mysql> SELECT 'Bn' REGEXP '^Ba*n';
+---------------------+
| 'Bn' REGEXP '^Ba*n' |
+---------------------+
|                   1 |
+---------------------+
1 row in set (0.00 sec)