bitand
Description
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
andy
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)