xxxxxxxxxx
select initcap("hometown") hometown, is the column name
FROM benn.college_football_players
xxxxxxxxxx
UPDATE tb_Company
SET CompanyIndustry = CONCAT(UCASE(LEFT(CompanyIndustry, 1)),
LCASE(SUBSTRING(CompanyIndustry, 2)));
xxxxxxxxxx
SELECT c1 FROM t1
WHERE CAST(LOWER(c1) AS BINARY) <> CAST(c1 AS BINARY);