MySQL bit operations

Bitwise OR:
Mysql> select 29 | 15;
-> 31
The result is an unsigned 64-bit integer.

&
Bitwise AND:
Mysql> select 29 & 15;
-> 13
The result is an unsigned 64-bit integer.

^
Bitwise XOR:
Mysql> select 1 ^ 1;
-> 0
Mysql> select 1 ^ 0;
-> 1
Mysql> select 11 ^ 3;
-> 8
The result is an unsigned 64-bit integer.

<
Shifts a Longlong (bigint) number to the left.
Mysql> select 1 <2;
-> 4
The result is an unsigned 64-bit integer.

>
Shifts a Longlong (bigint) number to the right.
Mysql> select 4> 2;
-> 1
The result is an unsigned 64-bit integer.

~
Invert all bits.
Mysql> select 5 &~ 1;
-> 4
The result is an unsigned 64-bit integer.

Bit_count (N)
Returns the number of bits that are set in the argument n.
Mysql> select bit_count (29 );
-> 4