UNHEX(str) interprets each pair of hexadecimal digits as a number and converts it to the character : UNHEX « String Functions « MySQL Tutorial






The resulting characters are returned as a binary string.

Performs the inverse operation of HEX(str).

mysql> SELECT UNHEX('4D7953514C');
+---------------------+
| UNHEX('4D7953514C') |
+---------------------+
| MySQL               |
+---------------------+
1 row in set (0.00 sec)

mysql>








23.46.UNHEX
23.46.1.UNHEX(str) interprets each pair of hexadecimal digits as a number and converts it to the character
23.46.2.UNHEX(HEX('string'));
23.46.3.HEX(UNHEX('1267'));
23.46.4.UNHEX('GG');