BIT_COUNT

Count the set bits. This function returns the number of bits that are set to 1 in the binary representation of a number.

Syntax

BIT_COUNT(N)

Description

Returns the number of bits that are set in the argument N.

Examples

SELECT BIT_COUNT(29), BIT_COUNT(b'101010');
+---------------+----------------------+
| BIT_COUNT(29) | BIT_COUNT(b'101010') |
+---------------+----------------------+
|             4 |                    3 |
+---------------+----------------------+

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}