In this MySQL tutorial post, we will see how we can convert text to uppercase. Uppercase means to convert all the text into capital letters.
In MySQL, text, string, or any value can be converted into uppercase by using UCASE or the UPPER function of MySQL.
- UCASE
- UPPER
Convert text to uppercase in MySQL by using Ucase
The general syntax of Ucase is Select UCASE("value_to_converted").
mysql> Select UCASE("This will be converted to upeercase");
+----------------------------------------------+
| UCASE("This will be converted to upeercase") |
+----------------------------------------------+
| THIS WILL BE CONVERTED TO UPEERCASE |
+----------------------------------------------+
1 row in set (0.06 sec)Convert text to uppercase in MySQL by using UPPER
The general syntax of UPPER is Select UPPER("value_to_converted").
mysql> Select UPPER("This will be converted to upeercase");
+----------------------------------------------+
| UPPER("This will be converted to upeercase") |
+----------------------------------------------+
| THIS WILL BE CONVERTED TO UPEERCASE |
+----------------------------------------------+
1 row in set (0.00 sec)