1UPDATE tb_Company
2SET CompanyIndustry = CONCAT(UCASE(LEFT(CompanyIndustry, 1)),
3 LCASE(SUBSTRING(CompanyIndustry, 2)));
1select initcap("hometown") hometown, is the column name
2FROM benn.college_football_players