{"id":11092,"date":"2023-10-13T00:43:06","date_gmt":"2023-10-13T07:43:06","guid":{"rendered":"https:\/\/www.mysqltutorial.org\/?page_id=11092"},"modified":"2023-10-13T01:56:19","modified_gmt":"2023-10-13T08:56:19","slug":"mysql-bin-function","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-string-functions\/mysql-bin-function\/","title":{"rendered":"MySQL BIN() Function"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the MySQL BIN()<\/code> function to return a string that represents the binary value of a number.<\/p>\n\n\n\n

Introduction to the MySQL BIN() function<\/h2>\n\n\n\n

The BIN()<\/code> function allows you to return a binary value of a number. <\/p>\n\n\n\n

Here’s the basic syntax of the BIN()<\/code> function:<\/p>\n\n\n

BIN(n)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this syntax, n<\/code> is a BIGINT<\/a><\/code> number. If n<\/code> is NULL<\/code>, the BIN()<\/code> function returns NULL<\/a><\/code>.<\/p>\n\n\n\n
The BIN(n)<\/code> is equivalent to CONV(n, 10, 2)<\/code>.<\/p>\n\n\n\n
MySQL BIN() function examples<\/h2>\n\n\n\n
Let’s take some examples of using the BIN()<\/code> function.<\/p>\n\n\n\n
1) Simple BIN() function example<\/h3>\n\n\n\n
The following example uses the BIN()<\/code> function to return a string that represents the binary value of the number 3:<\/p>\n\n\n
SELECT<\/span> BIN<\/span>(3<\/span>);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
+--------+<\/span>\n| BIN(3) |\n+--------+<\/span>\n| 11     |\n+--------+<\/span>\n1 row in set<\/span> (0.00<\/span> sec)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
2) Using the BIN() function with table data<\/h3>\n\n\n\n
First, create a new table<\/a> called permissions<\/code> that has two columns id<\/code> and flags<\/code>:<\/p>\n\n\n
CREATE<\/span> TABLE<\/span> permissions(\n    id<\/span> INT<\/span> AUTO_INCREMENT PRIMARY KEY<\/span>,\n    flags INT<\/span> NOT<\/span> NULL<\/span>\n);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
INSERT<\/span> INTO<\/span> permissions(flags)\nVALUES<\/span>\n  (3<\/span>),\n  (5<\/span>),\n  (7<\/span>);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Third, use the BIN()<\/code> function to query and represent the values in the flags<\/code> column in binary form:<\/p>\n\n\n
SELECT<\/span> \n  id<\/span>, \n  flags, \n  BIN<\/span>(flags) \nFROM<\/span> \n  permissions;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
+----+-------+------------+<\/span>\n| id | flags | BIN(flags) |\n+----+-------+------------+<\/span>\n|  1 |     3 | 11         |\n|  2 |     5 | 101        |\n|  3 |     7 | 111        |\n+----+-------+------------+<\/span>\n3 rows in set<\/span> (0.00<\/span> sec)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Summary<\/h2>\n\n\n\n
    \n
  • Use the MySQL BIN()<\/code> function to get a string that represents the binary value of a number.<\/li>\n<\/ul>\n
    \n\t
    \n\t\t
    Was this tutorial helpful? <\/div>\n\t\t
    \n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
    \n\t\t
    \n\t\t\t
    <\/div>\n\t\t\t\n\t\t\t
Second, insert some rows<\/a> into the permissions<\/code> table:<\/p>\n\n\n