Skip to main content
Version: Latest-3.5

bitand

Returns the bitwise AND of two numeric expressions.

Syntax​

BITAND(x,y);

Parameters​

  • x: This expression must evaluate to any of the following data types: TINYINT, SMALLINT, INT, BIGINT, LARGEINT.

  • y: This expression must evaluate to any of the following data types: TINYINT, SMALLINT, INT, BIGINT, LARGEINT.

x and y must agree in data type.

Return value​

The return value has the same type as x. If any value is NULL, the result is NULL.

Examples​

mysql> select bitand(3,0);
+--------------+
| bitand(3, 0) |
+--------------+
|            0 |
+--------------+
1 row in set (0.01 sec)