Categories:

Conditional Expression Functions

BOOLAND¶

Computes the Boolean AND of two numeric expressions. In accordance with Boolean semantics:

  • Non-zero values (including negative numbers) are regarded as True.

  • Zero values are regarded as False.

As a result, the function returns:

  • True if both expressions are non-zero.

  • False if both expressions are zero or one expression is zero and the other expression is non-zero or NULL.

  • NULL if both expressions are NULL or one expression is NULL and the other expression is non-zero.

See also:

BOOLNOT , BOOLOR , BOOLXOR

Syntax¶

BOOLAND( expr1 , expr2 )
Copy

Examples¶

SELECT BOOLAND(1, -2), BOOLAND(0, 2.35), BOOLAND(0, 0), BOOLAND(0, NULL), BOOLAND(NULL, 3), BOOLAND(NULL, NULL);

+----------------+------------------+---------------+------------------+------------------+---------------------+
| BOOLAND(1, -2) | BOOLAND(0, 2.35) | BOOLAND(0, 0) | BOOLAND(0, NULL) | BOOLAND(NULL, 3) | BOOLAND(NULL, NULL) |
|----------------+------------------+---------------+------------------+------------------+---------------------|
| True           | False            | False         | False            | NULL             | NULL                |
+----------------+------------------+---------------+------------------+------------------+---------------------+
Copy