Mysql capitalize first letter

Here CONCAT() function used to capitalize first letter of the column.

Example:

select CONCAT(UPPER(LEFT(HeadType,1)), LOWER(SUBSTRING(HeadType,2,LENGTH(HeadType)))) HeadType from headtype;

Result: