!=

Overview

Not equal to.

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

EXAMPLES

SELECT 42 != 42, 1 != 0;
+----------+--------+
| 42 != 42 | 1 != 0 |
+----------+--------+
|        0 |      1 |
+----------+--------+
CREATE TABLE not_eq_example (
  description VARCHAR(20),
  example INT
);
INSERT INTO not_eq_example VALUES
  ('Everything', 42),
  ('Dalmations', 101),
  ('Agent', 99),
  ('B. Doz.', 13),
  ('CPU', 64);
SELECT * FROM not_eq_example
WHERE example != 101 AND 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