MYSQL: set first letter of field to uppercase

I recently had to set values of a set of values from a column from lowercase to Firstuppercase. Nothing easier, run the following code on the database:

1
2
3

UPDATE `affected_table` SET
`field_in_question` = CONCAT(UPPER(LEFT(`field_in_question`, 1)),
SUBSTRING(`field_in_question`, 2))

Tags: lowercase, mysql, uppercase