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.

## Syntax¶

BOOLAND( expr1 , expr2 )


## 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                |
+----------------+------------------+---------------+------------------+------------------+---------------------+