&

Description

Bitwise AND operator returns an unsigned 64-bit integer.

The result type depends on whether the arguments are evaluated as binary strings or numbers:

  • Binary-string evaluation occurs when the arguments have a binary string type, and at least one of them is not a hexadecimal literal, bit literal, or NULL literal. Numeric evaluation occurs otherwise, with argument conversion to unsigned 64-bit integers as necessary.

  • Binary-string evaluation produces a binary string of the same length as the arguments. If the arguments have unequal lengths, an ER_INVALID_BITWISE_OPERANDS_SIZE error occurs. Numeric evaluation produces an unsigned 64-bit integer.

Syntax

  1. > SELECT value1 & value2;

Examples

  1. mysql> SELECT 29 & 15;
  2. +---------+
  3. | 29 & 15 |
  4. +---------+
  5. |      13 |
  6. +---------+
  7. 1 row in set (0.06 sec)
  9. CREATE TABLE bitwise (a_int_value INT NOT NULL,b_int_value INT NOT NULL);
  10. INSERT bitwise VALUES (170, 75);  
  12. mysql> SELECT a_int_value & b_int_value FROM bitwise;  
  13. +---------------------------+
  14. | a_int_value & b_int_value |
  15. +---------------------------+
  16. |                        10 |
  17. +---------------------------+
  18. 1 row in set (0.02 sec)