SOME
This page is part of MariaDB's Documentation.
The parent of this page is: SQL Operators for MariaDB Xpand
Topics on this page:
Overview
See ANY.
USAGE
value = SOME (SELECT ...)
Value Name | Description |
---|---|
| A value expression |
| A SELECT that returns single-value rows |
EXAMPLES
CREATE TABLE some_example (
description VARCHAR(20),
example INT
);
INSERT INTO some_example VALUES
('Everything', 42),
('Dalmations', 101),
('Agent', 99),
('B. Doz.', 13),
('CPU', 64);
CREATE TABLE some_example_values (
val INT
);
INSERT INTO some_example_values VALUES
(42), (64), (99);
SELECT *
FROM some_example
WHERE example = SOME (
SELECT val
FROM some_example_values
);
+-------------+---------+
| description | example |
+-------------+---------+
| Everything | 42 |
| Agent | 99 |
| CPU | 64 |
+-------------+---------+