Skip to main content

Logical/Boolean Operators

Logical/Boolean Operators.

Syntax

OperatorSyntaxDescription
ANDa AND bMatches both expressions (a and b).
NOTNOT aDoes not match the expression.
ORa OR bMatches either expression.

Examples

SELECT 1 AND 1;
+-----------+
| (1 and 1) |
+-----------+
| 1 |
+-----------+

SELECT 1 AND 0;
+-----------+
| (1 and 0) |
+-----------+
| 0 |
+-----------+

SELECT 1 AND NULL;
+--------------+
| (1 and NULL) |
+--------------+
| NULL |
+--------------+

SELECT 0 AND NULL;
+--------------+
| (0 and NULL) |
+--------------+
| 0 |
+--------------+

SELECT 1 OR 0;
+----------+
| (1 or 0) |
+----------+
| 1 |
+----------+

SELECT 0 OR 0;
+----------+
| (0 or 0) |
+----------+
| 0 |
+----------+

SELECT NOT 10;
+----------+
| (not 10) |
+----------+
| 0 |
+----------+

SELECT NOT 0;
+---------+
| (not 0) |
+---------+
| 1 |
+---------+

SELECT NOT NULL;
+------------+
| (not NULL) |
+------------+
| NULL |
+------------+

SELECT 1 OR 0;
+-----------+
| (1 or 0) |
+-----------+
| 1 |
+-----------+

SELECT 1 OR 1;
+-----------+
| (1 or 1) |
+-----------+
| 0 |
+-----------+

SELECT 1 OR NULL;
+--------------+
| (1 or NULL) |
+--------------+
| NULL |
+--------------+