ANY

Overview

Presence in any returned rows.

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

EXAMPLES

CREATE TABLE any_example (
  description VARCHAR(20),
  example INT
);

CREATE TABLE any_example_values (
  val INT
);
INSERT INTO any_example VALUES
  ('Everything', 42),
  ('Dalmations', 101),
  ('Agent', 99),
  ('B. Doz.', 13),
  ('CPU', 64);

INSERT INTO any_example_values VALUES
  (42), (64), (99);
SELECT * FROM any_example
WHERE example = ANY (SELECT val FROM any_example_values);
+-------------+---------+
| 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