MySQL NOT Condition

The MySQL NOT condition is opposite of MySQL IN condition. It is used to negate a condition in a SELECT, INSERT, UPDATE or DELETE statement.

Syntax:

snippet

NOT condition

Parameter

condition: It specifies the conditions that you want to negate.

Consider a table "officers", having the following data.

Execute the following query:

snippet

SELECT *
FROM officers
WHERE officer_name NOT IN ('Ajeet','Vimal','Deepika');

Output:

Execute the following query:

snippet

SELECT *
FROM officers
WHERE officer_name IS NOT NULL;

Output:

We are taking the same table "officer" for this operation also:

Execute the following query:

snippet

SELECT *
FROM officers
WHERE officer_name NOT LIKE 'A%';

Output:

We are taking the same table "officer" for this operation also:

Execute the following query:

snippet

SELECT *
FROM officers
WHERE officer_id NOT BETWEEN 3 AND 5;

Output:

Related Tutorial

1 MySQL AND Condition

2 MySQL OR Condition

3 MySQL AND & OR condition

4 MySQL Boolean

5 MySQL LIKE condition

6 MySQL IN Condition

7 MySQL NOT Condition

8 MySQL Not Equal

9 MySQL IS NULL Condition

10 MySQL IS NOT NULL Condition

11 MySQL BETWEEN Condition

Try it

Contents +