In PHP we would use UCFIRST, so how do we do this in MySQL? SELECT CONCAT(UPPER(SUBSTRING(firstName, 1, 1)), LOWER(SUBSTRING(firstName FROM 2))) AS properFirstName You could also create your own MySQL function of this and then just call it, instead of