MySQL in a Nutshell

Name

LCASE( )

Synopsis

LCASE(string)

This function converts a string of text or a string from a column given to all lowercase letters. An alias to LOWER( ).

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

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, a combination of the LEFT( ) function and the SUBSTRING() function is used in conjunction with the UCASE( ) function and the LCASE( ) function.