Mega Code Archive

 

Categories / MySQL / Regular Expression

 

The asterisk () indicates zero or more

mysql> mysql> SELECT 'abcdef' REGEXP 'g*'; +----------------------+ | 'abcdef' REGEXP 'g*' | +----------------------+ |                    1 | +----------------------+ 1 row in set (0.00 sec)