taking first letter in mysql query code example

Example 1: mysql query first character

SELECT author FROM lyrics WHERE author LIKE 'B%';

Example 2: first letter capital in mysql query

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