Regular Expressions MySQL Tutorial

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