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: View Code SQL1 2 3 UPDATE `affected_table` SET `field_in_question` = CONCAT(UPPER(LEFT(`field_in_question`, 1)), SUBSTRING(`field_in_question`, 2))

Read more »