string - Capitalize first letter. MySQL

itemprop="text">

Does any one know the equivalent to
this TSQL in MySQL parlance?

I am
trying to capitalize the first letter of each
entry.

UPDATE tb_Company SET
            CompanyIndustry = UPPER(LEFT(CompanyIndustry, 1))
+ SUBSTRING(CompanyIndustry,
            2, LEN(CompanyIndustry))

Answer

It's almost the same, you just have to change
to use the CONCAT() function instead of the + operator
:

UPDATE tb_Company
SET
            CompanyIndustry = CONCAT(UCASE(LEFT(CompanyIndustry, 1)), 


            SUBSTRING(CompanyIndustry,
            2));

This would turn
hello to Hello,
wOrLd to WOrLd,
BLABLA to BLABLA, etc. If you want to
upper-case the first letter and lower-case the other, you just have to use LCASE
function :

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

Note
that UPPER and UCASE do the same thing.