bitwise AND (&)
Combines two integers to produce a third integer whose binary bits are 1 if and only if both bits in the input numbers are also 1.
Syntax
19 = 10011 21 = 10101 & ----------- 17 = 10001
num1 & num2
Return Type
Integer
Examples
SELECT 19 & 21, bin(19), bin(21), bin(19 & 21); **** +---------+---------+---------+--------------+ | 19 & 21 | bin(19) | bin(21) | bin(19 & 21) | +---------+---------+---------+--------------+ | 17 | 10011 | 10101 | 10001 | +---------+---------+---------+--------------+