&

Operator Description

Bitwise AND operator, performs an AND (AND) operation for each pair of bits. Only when a and b are both 1, a AND b is 1. Bitwise AND Returns an unsigned 64-bit integer.

The result type depends on whether the parameter is a binary string or a number:

When the parameters are of binary string type, and at least one of them is not hexadecimal literal, bit literal or NULL literal, binary string evaluation is performed; otherwise, numerical evaluation is performed and the parameters are converted to unsigned 64-bit integers as needed.
Binary string evaluation produces a binary string with the same length as the parameter. If the lengths of the parameters are not equal, an ER_INVALID_BITWISE_OPERANDS_SIZE error occurs. Numerical calculations produce an unsigned 64-bit integer.

Grammar Structure

> SELECT value1 & value2;

Example

mysql> SELECT 29 & 15;
+-----------+
| 29 & 15 |
+-----------+
| 13 |
+-----------+
1 row in set (0.06 sec)

CREATE TABLE bitwise (a_int_value INT NOT NULL,b_int_value INT NOT NULL);
INSERT bitwise VALUES (170, 75);

mysql> SELECT a_int_value & b_int_value FROM bitwise;
+--------------------------------+
| a_int_value & b_int_value |
+--------------------------------+
| 10 |
+--------------------------------+
1 row in set (0.02 sec)