MySQL UPPER is an inbuilt Function in MySQL. It converts a text to uppercase. In this article, we will discuss the MySQL UPPER Function. Also, we will discuss a few examples of using it.
This function is synonymous to MySQL UCASE Function. Also, you can convert text to lowercase using MySQL LOWER Function.
Syntax
UPPER (string)
Parameters
The Function expects only one parameter. You need to pass the string you need to convert in uppercase as the parameter.
Return Value
The function returns the input string to uppercase in MySQL.

Examples
Let’s see some examples to use the function in queries.
Example 1: Basic Query
You can use the UPPER Function to convert a string to uppercase in MySQL.
mysql> SELECT UPPER('bringing knowledge together') as UpperCase; +-----------------------------+ | UpperCase | +-----------------------------+ | BRINGING KNOWLEDGE TOGETHER | +-----------------------------+ 1 row in set (0.00 sec)
Example 2: SELECT Query
You can use the Upper Function in SELECT statements.
mysql> select UPPER(user_name) as UpperUserName from user_description; +---------------+ | UpperUserName | +---------------+ | CHANDLER | | MONICA | | ROSS | +---------------+ 3 rows in set (0.00 sec)
Example 3: UPDATE Query
You can also update the existing fields in a table using the function in an UPDATE Query.
mysql> UPDATE user_description SET user_name = UPPER(user_name); Query OK, 3 rows affected (0.07 sec) Rows matched: 3 Changed: 3 Warnings: 0 mysql> select user_name from user_description; +-----------+ | user_name | +-----------+ | CHANDLER | | MONICA | | ROSS | +-----------+ 3 rows in set (0.00 sec)
Conclusion
In this article, we discussed the UPPER Function. It converts a text to uppercase in MySQL. You can read more about it on the Official MySQL Documentation. Also, read more about MySQL String Functions on Concatly.
Also, you can convert text to lowercase using MySQL LOWER Function.

Vishesh is currently working as an Intermediate Software Engineer with Orion Health, New Zealand. He graduated with a Masters in Information Technology from the University of Auckland in 2021. With more than 4 years of work experience, his expertise includes Java, Python, Machine Learning, PHP, Databases, Design and Architecture.