UNHEX() FUNCTION in MySQL
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.