AND
This page is part of MariaDB's Enterprise Documentation.
The parent of this page is: SQL Operators
Topics on this page:
Overview
Logical And. Evaluates to 1 if both operators are non-zero, 0 if one or both operators are 0, NULL if either is NULL.
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
DETAILS
SYNONYMS
The following are synonyms for AND:
&&
EXAMPLES
SELECT TRUE AND TRUE, FALSE AND FALSE;
+---------------+-----------------+
| TRUE AND TRUE | FALSE AND FALSE |
+---------------+-----------------+
| 1 | 0 |
+---------------+-----------------+
SELECT TRUE AND FALSE, FALSE AND TRUE;
+----------------+----------------+
| TRUE AND FALSE | FALSE AND TRUE |
+----------------+----------------+
| 0 | 0 |
+----------------+----------------+
CREATE TABLE and_example (
v1 INT,
v2 INT
);
INSERT INTO and_example VALUES
(0, 9), (1, 8), (2, 7), (3, 6), (4, 5),
(5, 4), (6, 3), (7, 2), (8, 1), (9, 0);
SELECT * from and_example
WHERE v1 > 3 AND v2 > 3;
+------+------+
| v1 | v2 |
+------+------+
| 4 | 5 |
| 5 | 4 |
+------+------+
CHANGE HISTORY
Release Series | History |
---|---|
10.6 Enterprise |
|
10.6 Community |
|
10.5 Enterprise |
|
10.5 Community |
|
10.4 Enterprise |
|
10.4 Community |
|
10.3 Enterprise |
|
10.3 Community |
|
10.2 Enterprise |
|
10.2 Community |
|
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.
Information specific to MariaDB SkySQL can be found on the AND page in the SkySQL Documentation.