BIT_COUNT

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}