#Fixing names column so only first letter is uppercase. Table: Users +----------------+---------+ | Column Name | Type | +----------------+---------+ | user_id | int | | name | varchar | +----------------+---------+ select user_id, CONCAT (UPPER(LEFT(name,1)), LOWER(right(name,LENGTH(name)-1))) as name from Users ORDER BY user_id;