MySQL NOT RLIKE Operator
Updated on
MySQL NOT RLIKE selects strings that do not match a regular expression. It is a synonym for NOT REGEXP, which is equivalent to NOT (expr RLIKE pattern).
Syntax
expr NOT RLIKE pattern
Example
SELECT code
FROM products
WHERE code NOT RLIKE '^[0-9]+$';
The query returns product codes that contain at least one non-digit character. If either operand is NULL, the predicate result is NULL, so the row does not pass a WHERE clause. For explicit case control, use REGEXP_LIKE() with its match_type argument.