UNHEX
Converts a hexadecimal representation to the binary equivalent.
Syntax
UNHEX(expression)
Arguments
expression
A hexadecimal expression, in upper or lower case.
Return Type
Binary data.
Examples
SELECT HEX('ohai');
****
+-------------+
| HEX('ohai') |
+-------------+
| 6F686169 |
+-------------+
SELECT UNHEX('6F686169');
****
+-------------------+
| UNHEX('6F686169') |
+-------------------+
| ohai |
+-------------------+