Capitalizing the first letter of a name Column in a mySQL table using phpMyadmin Wed-Oct-2022 UPDATE states SET name = CONCAT(UCASE(SUBSTRING(name, 1, 1)),LCASE(SUBSTRING(name, 2))); 14