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)
  11. mysql> select group_bit_and(value) from group_bit;
  12. +------------------------+
  13. | group_bit_and(`value`) |
  14. +------------------------+
  15. | 0 |
  16. +------------------------+

keywords

  1. GROUP_BIT_AND,BIT