UPPER Function in MYSQL

In MySQL, the UPPER() function is used to convert a string to uppercase. Here's how you can use it with an example:

Suppose you have a table users with a column name, and you want to retrieve the names of all users in uppercase:

SELECT UPPER(name) AS uppercase_name

FROM users;

This query will retrieve the name column values from the users table and convert them to uppercase using the UPPER() function. The result set will contain the uppercase names, and they will be aliased as uppercase_name.