UNHEX() FUNCTION
The MySQL UNHEX function is used to convert a hexadecimal value to a string.
Syntax:
UNHEX (value);
Parameters:
value: It is used to specify the hexadecimal value to convert.
Example:
mysql> SELECT UNHEX (‘41’); |
Output:
‘A’ |
Explanation:
The string for the specified hexadecimal value is returned.
Please Share