Capitalizing the first letter of a name Column in a mySQL table using phpMyadmin Home » Capitalizing the first letter of a name Column in a mySQL table using phpMyadmin Posted on October 12, 2022 AdminLatest In How-To Geek 190 UPDATE states SET name = CONCAT(UCASE(SUBSTRING(name, 1, 1)),LCASE(SUBSTRING(name, 2)));