Skip to content

NOT REGEXP

Function Description

NOT REGEXP is used to test whether a string does not match the specified regular expression.

If column_name does not match pattern, TRUE is returned. If it matches, FALSE is returned.

grammar

> column_name NOT REGEXP pattern

Parameter definition

  • column_name is the field to match.

  • pattern is the regular expression to be applied.

Example

CREATE TABLE example (
         id INT AUTO_INCREMENT,
         text VARCHAR(255),
         PRIMARY KEY(id)
         );


INSERT INTO example (text)
  VALUES ('Hello1'),
         ('Hello2'),
         ('World'),
         ('HelloWorld'),
         ('Hello_World'),
         ('example'),
         ('example1'),
         ('example2');

mysql> SELECT * FROM example WHERE text NOT REGEXP '[0-9]';
+-------+-----------------+
| id | text |
+-------+-----------------+
| 3 | World |
| 4 | HelloWorld |
| 5 | Hello_World |
| 6 | example |
+-------+-----------------+
4 rows in set (0.00 sec)