BIN
Returns a string representation of the binary value of N, where N is a longlong (BIGINT) number.
This is equivalent to CONV(N,10,2).
Syntax
BIN ( expression )
Notice
The function BINARY is not an alias for BIN.
Arguments
expression: any valid numeric expression.
Return Type
A string containing numeric value, in binary. Float values are truncated. Returns NULL if expression is NULL.
Examples
SELECT BIN(1234); +-------------+ | BIN(1234) | +-------------+ | 10011010010 | +-------------+ SELECT BIN(1234.5678); +----------------+ | BIN(1234.5678) | +----------------+ | 10011010010 | +----------------+