bitand

Description

Syntax:

BITAND(Integer-type lhs, Integer-type rhs)

This function returns the result of AND operation of two integers.

Integer range: TINYINT、SMALLINT、INT、BIGINT、LARGEINT

Example

mysql> select bitand(3,5) ans;
+------+
| ans  |
+------+
|    1 |
+------+

mysql> select bitand(4,7) ans;
+------+
| ans  |
+------+
|    4 |
+------+

Keywords

BITAND