capitalise first letter with mysql

Quick note to myself...
When a column is wrongly capitalised in mysql, quicly sort it with:
use database;
UPDATE tablename SET columnname = CONCAT(UCASE(LEFT(columnname, 1)), LCASE(SUBSTRING(columnname, 2)));