Mysql string Functions

UNHEX()

MySQL UNHEX() function performs the opposite operation of HEX(). This function interprets each pair of hexadecimal digits (in the argument) as a number and converts it to a character.
Example : SELECT UNHEX('4D7953514C');
Syntax : UNHEX(str)
Output : MySQL
Example : SELECT UNHEX(HEX('MySQL'));
Output : MySQL

UPPER()

MySQL UPPER() converts all the characters in a string to uppercase characters.
Example : SELECT UPPER('myteststring');
Syntax : UPPER(str)
Output : MYTESTSTRING
Thank you for your Time and Attention!