UPPER(str)

UPPER() function returns the string str with all characters changed to uppercase according to the current character set mapping means if you want to get a string with all character in upper case then you can use this function.

Here is some example related to this-

mysql> SELECT UPPER('Hello mysql.');
+-----------------------+
| UPPER('Hello mysql.') |
+-----------------------+
| HELLO MYSQL.          |
+-----------------------+
1 row in set (0.00 sec)

mysql>  SET @str = BINARY 'Hello mysql';
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT UPPER(@str), UPPER(CONVERT(@str USING latin1));
+-------------+-----------------------------------+
| UPPER(@str) | UPPER(CONVERT(@str USING latin1)) |
+-------------+-----------------------------------+
| Hello mysql | HELLO MYSQL                       |
+-------------+-----------------------------------+
1 row in set (0.00 sec)