MySQL UCASE Function | Convert Text to Uppercase

MySQL UCASE is an inbuilt Function in MySQL. It converts a text to uppercase. In this article, we will discuss the MySQL UCASE Function. Also, we will discuss a few examples of using it.

This function is synonymous to MySQL UPPER Function.

Syntax

UCASE (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.

MySQL UCASE Function Diagram

Examples

Let’s see some examples to use the function in queries.

Example 1: Basic QueryYoucan

You can use the UCASE Function to convert a string to uppercase in MySQL.

mysql> SELECT UCASE('bringing knowledge together') as UpperCase;
+-----------------------------+
| UpperCase                   |
+-----------------------------+
| BRINGING KNOWLEDGE TOGETHER |
+-----------------------------+
1 row in set (0.00 sec)

Example 2: SELECT Query

You can use the UCASE Function in SELECT statements.

mysql> select UCASE(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 = UCASE(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 UCASE 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 LCASE Function.

Spread the Knowledge

Leave a Reply

Your email address will not be published. Required fields are marked *