BIT_COUNT
Given a number, return the number of ones in its binary representation.
Syntax
BIT_COUNT ( expression )
Arguments
expression: any valid numeric expression.
Return Type
The number of ones bits in the binary representation. Float values are truncated. Returns NULL if expression is NULL.
Examples
SELECT bit_count(8), bin(8); **** +--------------+--------+ | bit_count(8) | bin(8) | +--------------+--------+ | 1 | 1000 | +--------------+--------+
SELECT bit_count(1234), bin(1234); **** +-----------------+-------------+ | bit_count(1234) | bin(1234) | +-----------------+-------------+ | 5 | 10011010010 | +-----------------+-------------+
SELECT bit_count(240), bin(240); **** +----------------+----------+ | bit_count(240) | bin(240) | +----------------+----------+ | 4 | 11110000 | +----------------+----------+