# Logical/Boolean Operators

Logical/Boolean Operators.

## Syntax​

OperatorSyntaxDescription
`AND``a AND b`Matches both expressions (`a` and `b`).
`NOT``NOT a`Does not match the expression.
`OR``a OR b`Matches 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 |+--------------+``