Syntax:

UNHEX(str)

Performs the inverse operation of HEX(str). That is, it interprets each
pair of hexadecimal digits in the argument as a number and converts it
to the character represented by the number. The resulting characters
are returned as a binary string.

URL: http://dev.mysql.com/doc/refman/5.1/en/string-functions.html

