MySQL BIN() function

BIN() function

MySQL BIN() returns the corresponding string representation of the binary value of a BIGINT number. It returns NULL if the number is NULL. The equivalent of BIN() is CONV(N,10,2), where N is a BIGINT number.

Syntax:

BIN(num1)

Argument:

Syntax Diagram:

MySQL Version: 5.6

Video Presentation:

Example: MySQL BIN() function

The following MySQL statement returns the string representation of 255, i.e. '11111111'.

Code:

SELECT BIN(255);

Sample Output:

mysql> SELECT BIN(255);
+----------+
| BIN(255) |
+----------+
| 11111111 | 
+----------+
1 row in set (0.01 sec)

All String Functions

Previous: ASCII
Next: BIT_LENGTH