Match any sequence of zero or more a characters : Zero or More : Regular Expressions MySQL TUTORIALS

MySQL TUTORIALS » Regular Expressions » Zero or More »

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)