bitand

description

Syntax

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

返回两个整数与运算的结果.

整数范围: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. +------+

keyword

1. BITAND