Name

BIT_COUNT()

Synopsis

BIT_COUNT(number)

This function returns the number of bits set in the argument, which is an integer that the function treats as a binary number.

SELECT BIT_COUNT(10), BIT_COUNT(11);

+---------------+---------------+
| BIT_COUNT(10) | BIT_COUNT(11) |
+---------------+---------------+
|             2 |             3 |
+---------------+---------------+

Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.