You are viewing the archived documentation of TiDB, which no longer receives updates.View latest LTS version docs ↗

Bit Functions and Operators

In TiDB, the usage of bit functions and operators is similar to MySQL. See Bit Functions and Operators.

Bit functions and operators

Name	Description
`BIT_COUNT()`	Return the number of bits that are set as 1
&	Bitwise AND
~	Bitwise inversion
\|	Bitwise OR
^	Bitwise XOR
<<	Left shift
>>	Right shift