mysql>mysql> SELECT 'aXbc' REGEXP '^[a-dXYZ]+$';+-----------------------------+| 'aXbc' REGEXP '^[a-dXYZ]+$' |+-----------------------------+| 1 |+-----------------------------+1 row in set (0.00 sec)