MySQL NOT

You can use NOT logical operator with SELECT, INSERT and UPDATE

Syntax

SELECT column1, column2, ...
FROM table_name
WHERE NOT condition;

Example

SELECT name FROM employees WHERE NOT name='John'