mysql Convert the first letter of each word in Uppercase code example
Example: first letter capital in mysql query
UPDATE tb_Company
SET CompanyIndustry = CONCAT(UCASE(LEFT(CompanyIndustry, 1)),
LCASE(SUBSTRING(CompanyIndustry, 2)));