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>