mysql> mysql> SELECT 'ABC' REGEXP '^Aa+'; +---------------------+ | 'ABC' REGEXP '^Aa+' | +---------------------+ | 0 | +---------------------+ 1 row in set (0.00 sec) mysql> mysql> SELECT 'ABC' REGEXP '^ABa+'; +----------------------+ | 'ABC' REGEXP '^ABa+' | +----------------------+ | 0 | +----------------------+ 1 row in set (0.00 sec) mysql>
24.9.One or More | ||||
24.9.1. | Match any sequence of one or more a characters: a+ | |||
24.9.2. | Get first name with one or more J character: J+ |