UNHEX() Function in MySQL

UNHEX() function in MySQL is used to convert the Hexadecimal number into the bytes represented by the Number. The value returned by it is a binary string.

Syntax :

UNHEX(str)

Parameter : Required.
str : It is a string which is to be converted into the byte represented by the number.
Returns : It returns a binary string. If non-hexadecimal digits are provided this function returns NULL.

Example-1 :
Using UNHEX() function to a string.

SELECT UNHEX('6765656B73666F726765656B73') AS String_Name;

Output :

String_Name
geeksforgeeks

Example-2 :
Using UNHEX() function to another string.

SELECT UNHEX('48656C6C6F') AS String_Name;

Output :

String_Name
Hello

Example-3 :
Using UNHEX() function to a non-hexadecimal string.

SELECT UNHEX('www') AS String_Name;

Output :

String_Name
NULL