Answers for "convert letter to capital mysql"

first letter capital in mysql query

UPDATE tb_Company
SET CompanyIndustry = CONCAT(UCASE(LEFT(CompanyIndustry, 1)), 
                             LCASE(SUBSTRING(CompanyIndustry, 2)));

Posted by: Guest on July-09-2020

Code answers related to "convert letter to capital mysql"