MySQL NOT REGEXP Operator

NOT REGEXP in MySQL is a negation of the REGEXP operator used for pattern matching. It compares the given pattern in the input string and returns the result, which does not match the patterns. If this operator finds a match, the result is 0. Otherwise, the result is 1.

Syntax

The following is a basic syntax to use this operator in MySQL:

In this syntax, the expression is an input string on which we will perform searching for matching the regular expression. And pattern represents the regular expression for which we are testing the string. This syntax is generally used with the SELECT statements.

The above syntax is equivalent to the below statement:

Let us understand how this operator works in MySQL through examples.

Example

The below statement is the most basic example to use the NOT REGEXP operator. Here we have just used a string and compare it with a regular expression to check whether any part of the input string matches the pattern or not.

Here is the result:

The below statement is another example where the pattern matches if the given string starts with Java. Since the given string matched with Java but due to the negation of the REGEXP operator, we will get the output 0.

Here is the result:

Suppose we have a table named employee that contains the following data.

If we want to get the employee detail whose name does not start with j or s, we can do this as follows:

Executing the statement, we will get the desired result. See the below output: