MySQL in a Nutshell, 2nd Edition

Name

LCASE()

Synopsis

LCASE(string)

This function converts a string given to all lowercase letters. It’s an alias of LOWER(). Here is an example:

SELECT teacher_id,
CONCAT(LEFT(UCASE(name_last), 1),
SUBSTRING(LCASE(name_last), 2))
AS Teacher
FROM teachers;

In this example, we’re using a combination of LEFT() paired with UCASE() and SUBSTRING() paired with LCASE() to ensure that the first letter of the teacher’s name is displayed in uppercase and the rest of the name is in lowercase letters.