MySQL UNHEX is one of the String functions, which is to convert the Hexadecimal number into the bytes represented by the Number. The return value of this method is a binary string. We can call this UNHEX function as an inverse of HEX(), and the basic syntax of it is as shown below:
The characters that we specify as the MySQL UNHEX function argument must represent legal hexadecimal digits, such as 0 to 9, A to F, and a to f. If you provide any of the non-hexadecimal digits, it returns NULL.
MySQL UNHEX Function Example
The UnHexadecimal Function in MySQL converts the Hexadecimal digits to a string. The following String Function query shows you multiple ways to use this UNHEX function.
Let me take another MySQL example. Please refer to HEX() method article.