What MySQL functions can we use to change the character case of a string?

We can use LCASE() and LOWER() functions for changing the character case of a string to lower case and UCASE() and UPPER() functions for changing the character case of a string to upper case.

Example

mysql> Select LCASE('NEW DELHI'); +--------------------+ | LCASE('NEW DELHI') | +--------------------+ | new delhi          | +--------------------+ 1 row in set (0.00 sec) mysql> Select LOWER('NEW DELHI'); +--------------------+ | LOWER('NEW DELHI') | +--------------------+ | new delhi          | +--------------------+ 1 row in set (0.00 sec) mysql> Select UCASE('new delhi'); +--------------------+ | UCASE('new delhi') | +--------------------+ | NEW DELHI          | +--------------------+ 1 row in set (0.00 sec) mysql> Select UPPER('new delhi'); +--------------------+ | UPPER('new delhi') | +--------------------+ | NEW DELHI          | +--------------------+ 1 row in set (0.00 sec)

We can also use these functions with the columns of a table. For example, suppose we want to change the character case of the values in a column in the output then following query on table ‘Student’ can demonstrate it −

mysql> Select Name, UCASE(Name) from student; +---------+-------------+ | Name    | UCASE(Name) | +---------+-------------+ | Gaurav  | GAURAV      | | Aarav   | AARAV       | | Harshit | HARSHIT     | | Gaurav  | GAURAV      | | Yashraj | YASHRAJ     | +---------+-------------+ 5 rows in set (0.00 sec) mysql> Select Name, LCASE(Name) from student; +---------+-------------+ | Name    | LCASE(Name) | +---------+-------------+ | Gaurav  | gaurav      | | Aarav   | aarav       | | Harshit | harshit     | | Gaurav  | gaurav      | | Yashraj | yashraj     | +---------+-------------+ 5 rows in set (0.00 sec) mysql> Select Name, UPPER(Name) from student; +---------+-------------+ | Name    | UPPER(Name) | +---------+-------------+ | Gaurav  | GAURAV      | | Aarav   | AARAV       | | Harshit | HARSHIT     | | Gaurav  | GAURAV      | | Yashraj | YASHRAJ     | +---------+-------------+ 5 rows in set (0.00 sec) mysql> Select Name, LOWER(Name) from student; +---------+-------------+ | Name    | LOWER(Name) | +---------+-------------+ | Gaurav  | gaurav      | | Aarav   | aarav       | | Harshit | harshit     | | Gaurav  | gaurav      | | Yashraj | yashraj     | +---------+-------------+ 5 rows in set (0.00 sec)