MySQL BIN() Function

Return a binary representation of 15:

SELECT BIN(15);

Definition and Usage

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

BIN(number)

Parameter	Description
number	Required. A number

Works in:	From MySQL 4.0

Return a binary representation of 111:

SELECT BIN(111);

Return a binary representation of 8:

SELECT BIN(8);