ANY
This page is part of MariaDB's Documentation.
The parent of this page is: SQL Operators for MariaDB Xpand
Overview
Presence in any returned rows.
USAGE
value = ANY (SELECT ...)
Value Name | Description |
|---|---|
| A value expression |
| 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
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 |
+-------------+---------+