MySQL NOT
Last Updated: March 12, 2022
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'