AND

AND, &&

Syntax

MYSQL Copy

SELECT 1 AND 1;
1
SELECT 1 AND 0;
0
SELECT 1 AND NULL;
NULL
SELECT 0 AND NULL;
0
SELECT NULL AND 0;
0

Examples

Example

Logical AND. Evaluates to 1 if all operands are nonzero and not NULL, to 0 if one or more operands are 0, otherwise NULL is returned.

MYSQL Copy

SELECT 1 AND 1;
1
SELECT 1 AND 0;
0
SELECT 1 AND NULL;
NULL
SELECT 0 AND NULL;
0
SELECT NULL AND 0;
0