BIN

Retrieve the binary representation of the decimal number 15.

SELECT BIN(15);

Definition and Usage

The BIN() function returns the binary representation of a number as a string value.

BIN(number)

Parameter	Description
number	Required: A numerical value

Works in:

From MySQL version 4.0

Retrieve the binary representation of the decimal number 111.

SELECT BIN(111);

Retrieve the binary representation of the decimal number 8.

SELECT BIN(8);