!=
This page is part of MariaDB's MariaDB Documentation.
The parent of this page is: SQL Operators for MariaDB Enterprise Server
Topics on this page:
Overview
Not equal to.
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
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.