group_bit_and

description

Syntax

expr GROUP_BIT_AND(expr)

Perform an and calculation on expr, and return a new expr. All ints are supported

example

1. mysql> select * from group_bit;
2. +-------+
3. | value |
4. +-------+
5. |     3 |
6. |     1 |
7. |     2 |
8. |     4 |
9. +-------+
10. 4 rows in set (0.02 sec)

12. mysql> select group_bit_and(value) from group_bit;
13. +------------------------+
14. | group_bit_and(`value`) |
15. +------------------------+
16. |                      0 |
17. +------------------------+

keywords

1. GROUP_BIT_AND,BIT