Capitalizing the first letter of a name Column in a mySQL table using phpMyadminHome » Capitalizing the first letter of a name Column in a mySQL table using phpMyadmin Posted on October 12, 2022 AdminLatest In Blogs 191UPDATE states SET name = CONCAT(UCASE(SUBSTRING(name, 1, 1)),LCASE(SUBSTRING(name, 2)));