mysql>mysql> SELECT 'ian' REGEXP 'iai*n';+----------------------+| 'ian' REGEXP 'iai*n' |+----------------------+| 1 |+----------------------+1 row in set (0.00 sec)