Mega Code Archive

 

Categories / MySQL / String

 

Get the decimal values that belong to the binary representations 1001 and 111

mysql> mysql> mysql> SELECT CONV(1001,2,10), CONV(111,2,10); +-----------------+----------------+ | CONV(1001,2,10) | CONV(111,2,10) | +-----------------+----------------+ | 9               | 7              | +-----------------+----------------+ 1 row in set (0.00 sec) mysql>