ANY

Overview

Presence in any returned rows.

USAGE

value = ANY (SELECT ...)

Value Name

Description

value

A value expression

SELECT ...

A SELECT that returns single-value rows

DETAILS

The ANY operator changes an equality expression from comparing against a single value into one that compares against one or more values returned from a SELECT statement.

If any of the selected values matches the value expression, then the equality is true. This is equivalent to using expression IN (SELECT ...)

SYNONYMS

The following are synonyms for ANY:

  • SOME

SCHEMA

PARAMETERS

SKYSQL

PRIVILEGES

EXAMPLES

CREATE TABLE any_example (
  description VARCHAR(20),
  example INT
);
INSERT INTO any_example VALUES
  ('Everything', 42),
  ('Dalmations', 101),
  ('Agent', 99),
  ('B. Doz.', 13),
  ('CPU', 64);
CREATE TABLE any_example_values (
  val INT
);
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 |
+-------------+---------+

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

23.09

  • Present starting in MariaDB Xpand 23.09.1.

6.1

  • Present starting in MariaDB Xpand 6.1.0.

6.0

  • Present starting in MariaDB Xpand 6.0.3.

5.3

  • Present starting in MariaDB Xpand 5.3.13.

Release Series

History

6.0

  • Present starting in MariaDB Xpand 6.0.3.

5.3

  • Present starting in MariaDB Xpand 5.3.13.

Release Series

History

6.1

  • Present starting in MariaDB Xpand 6.1.0.

EXTERNAL REFERENCES