how to specify that the next character of a string must be capital in mysql code example
Example: first letter capital in mysql query
UPDATE tb_Company
SET CompanyIndustry = CONCAT(UCASE(LEFT(CompanyIndustry, 1)),
LCASE(SUBSTRING(CompanyIndustry, 2)));