Syntax:

UNHEX(str)

For a string argument str, UNHEX(str) interprets each pair of
characters in the argument as a hexadecimal number and converts it to
the byte represented by the number. The return value is a binary
string.

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

