# **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**

```text
> column_name NOT REGEXP pattern
```

### Parameter definition

- `column_name` is the field to match.

- `pattern` is the regular expression to be applied.

## **Example**

```text
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)
```