Mega Code Archive

 

Categories / MySQL Tutorial / Regular Expressions

 

Match either zero or one a character

mysql> mysql> SELECT 'ABC' REGEXP '^Aa?C'; +----------------------+ | 'ABC' REGEXP '^Aa?C' | +----------------------+ |                    0 | +----------------------+ 1 row in set (0.00 sec) mysql> mysql> SELECT 'ABC' REGEXP '^ABa?C'; +-----------------------+ | 'ABC' REGEXP '^ABa?C' | +-----------------------+ |                     1 | +-----------------------+ 1 row in set (0.00 sec) mysql> mysql> SELECT 'ABC' REGEXP '^Ba?C'; +----------------------+ | 'ABC' REGEXP '^Ba?C' | +----------------------+ |                    0 | +----------------------+ 1 row in set (0.00 sec) mysql>