NOT LIKE

Overview

Performs pattern matching, negative.

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

USAGE

NOT LIKE text
NOT LIKE text ESCAPE character

EXAMPLES

CREATE TABLE not_like_example (
  description VARCHAR(20),
  example INT
);
INSERT INTO not_like_example VALUES
  ('Everything', 42),
  ('Dalmations', 101),
  ('Agent', 99),
  ('50% Off', 13),
  ('CPU', 64);
SELECT * FROM not_like_example
WHERE description NOT LIKE '%ing' AND description NOT LIKE '____t';
+-------------+---------+
| description | example |
+-------------+---------+
| Dalmations  |     101 |
| 50% Off     |      13 |
| CPU         |      64 |
+-------------+---------+
SELECT * FROM not_like_example
WHERE description NOT LIKE '%#%%' ESCAPE '#';
+-------------+---------+
| description | example |
+-------------+---------+
| Everything  |      42 |
| Dalmations  |     101 |
| Agent       |      99 |
| CPU         |      64 |
+-------------+---------+

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Present starting in MariaDB Community Server 10.2.0.

EXTERNAL REFERENCES