AND

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

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Present starting in MariaDB Community Server 10.2.0.

EXTERNAL REFERENCES