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 | +-------------------+