NOT REGEXP

Description

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

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

Syntax

  1. > column_name NOT REGEXP pattern

Explanations

  • column_name is the column to match.

  • pattern is the regular expression to apply.

Examples

  1. CREATE TABLE example (
  2.          id INT AUTO_INCREMENT,
  3.          text VARCHAR(255),
  4.          PRIMARY KEY(id)
  5.          );
  8. INSERT INTO example (text)
  9.   VALUES ('Hello1'),
  10.          ('Hello2'),
  11.          ('World'),
  12.          ('HelloWorld'),
  13.          ('Hello_World'),
  14.          ('example'),
  15.          ('example1'),
  16.          ('example2');
  18. mysql> SELECT * FROM example WHERE text NOT REGEXP '[0-9]';
  19. +------+-------------+
  20. | id   | text        |
  21. +------+-------------+
  22. |    3 | World       |
  23. |    4 | HelloWorld  |
  24. |    5 | Hello_World |
  25. |    6 | example     |
  26. +------+-------------+
  27. 4 rows in set (0.00 sec)