How to do a ‘Proper case’ formatting of a mysql column? December 9, 2023 by Tarik You can combine CONCAT and SUBSTRING: CONCAT(UCASE(SUBSTRING(`fieldName`, 1, 1)), LOWER(SUBSTRING(`fieldName`, 2)))