bitand

description

Syntax

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

Returns the result of the AND operation of two integers.

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

example

1. mysql> select bitand(3,5) ans;
2. +------+
3. | ans  |
4. +------+
5. |    1 |
6. +------+

8. mysql> select bitand(4,7) ans;
9. +------+
10. | ans  |
11. +------+
12. |    4 |
13. +------+

keywords

1. BITAND