Categories:

Conditional expression functions

BOOLORΒΆ

Computes the Boolean OR 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 or one expression is non-zero and the other expression is zero or NULL.

  • False if both expressions are zero.

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

See also:

BOOLAND , BOOLNOT , BOOLXOR

SyntaxΒΆ

BOOLOR( expr1 , expr2 )
Copy

ExamplesΒΆ

SELECT BOOLOR(1, 2), BOOLOR(-1.35, 0), BOOLOR(3, NULL), BOOLOR(0, 0), BOOLOR(NULL, 0), BOOLOR(NULL, NULL);

+--------------+------------------+-----------------+--------------+-----------------+--------------------+
| BOOLOR(1, 2) | BOOLOR(-1.35, 0) | BOOLOR(3, NULL) | BOOLOR(0, 0) | BOOLOR(NULL, 0) | BOOLOR(NULL, NULL) |
|--------------+------------------+-----------------+--------------+-----------------+--------------------|
| True         | True             | True            | False        | NULL            | NULL               |
+--------------+------------------+-----------------+--------------+-----------------+--------------------+
Copy