Bit Operators | Mastering MySQL 4

The bit operators are not used often. They allow you to work with bit values and perform bit calculations in your queries.

&

value1 & value2

Performs a bitwise AND. This converts the values to binary and compares the bits. Only if both of the corresponding bits are 1 is the resulting bit also 1.

For example:

mysql> SELECT 2&1; +-----+ | 2&1 | +-----+ |   0 | +-----+ mysql> SELECT 3&1; +-----+ | 3&1 | +-----+ |   1 | +-----+

|

value1 | value2

Performs a bitwise OR. This converts the values to binary and compares the bits. If either of the corresponding bits are 1, the resulting bit is also 1.

For example:

mysql> SELECT 2|1; +-----+ | 2|1 | +-----+ |   3 | +-----+

<<

value1 << value2

Converts value1 to binary and shifts the bits of value1 left by the amount of value2.

For example:

mysql> SELECT 2<<1; +------+ | 2<<1 | +------+ |    4 | +------+

>>

value1 >> value2

Converts value1 to binary and shifts the bits of value1 right by the amount of value2.

For example:

mysql> SELECT 2>>1; +------+ | 2>>1 | +------+ |    1 | +------+