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                |
+----------------+------------------+---------------+------------------+------------------+---------------------+
```
Language: English