NOT

Overview

Logical not.

See also: SQL Operators in 10.6 ES, in 10.5 ES, and in 10.4 ES

EXAMPLES

CREATE TABLE not_example (
  description VARCHAR(20),
  example INT
);
INSERT INTO not_example VALUES
  ('Everything', 42),
  ('Dalmations', 101),
  ('Agent', 99),
  ('B. Doz.', 13),
  ('CPU', 64);
SELECT * FROM not_example
WHERE NOT (example = 101 OR description = 'B. Doz.');
+-------------+---------+
| description | example |
+-------------+---------+
| Everything  |      42 |
| Agent       |      99 |
| CPU         |      64 |
+-------------+---------+

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES