MySQL BITWISE AND Operator

BITWISE AND Operator

MySQL BITWISE AND operator returns an unsigned 64-bit integer.

Syntax:

&

Example:

Code:

SELECT  2 & 15;

Explanation:

The above MySQL statement will return an unsigned integer for numbers specified in the argument.

Sample Output:

mysql> SELECT 2 & 15;
+--------+
| 2 & 15 |
+--------+
|      2 | 
+--------+
1 row in set (0.03 sec)

Previous: BIT_COUNT
Next: INVERT BITS