What is the method with the help of which the hexadecimal value can be treated as a number?

MySQLMySQLi Database

For treating the hexadecimal value as a number, we can use the CAST(… AS UNSIGNED) function. Following example will demonstrate it −

mysql> Select 0x54, CAST(0x54 AS UNSIGNED);
| 0x54 | CAST(0x54 AS UNSIGNED) |
| T    |                     84 |
1 row in set (0.01 sec)
Published on 21-Feb-2018 12:24:57