String MySQL

  1. Home
  2. MySQL
  3. String
  4. Get the binary representation of the values 6 and 10
mysql>
mysql>
mysql> SELECT CONV(6,10,2), CONV(10,10,2), BIN(8), BIN(10);
+--------------+---------------+--------+---------+
| CONV(6,10,2) | CONV(10,10,2) | BIN(8) | BIN(10) |
+--------------+---------------+--------+---------+
| 110          | 1010          | 1000   | 1010    |
+--------------+---------------+--------+---------+
1 row in set (0.00 sec)
mysql>