Mega Code Archive

 

Categories / MySQL Tutorial / Regular Expressions

 

SELECT abcda REGEXP ^[^a-dXYZ]+$

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