w3resource
MYSQL Tutorial

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

Name Description
num1 A number whose BINARY value is to be retrieved.

Syntax Diagram:

MySQL BIN() Function - 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

MySQL String Functions, slide presentation