Mega Code Archive

 

Categories / MySQL Tutorial / Regular Expressions

 

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)