09 november, 2014

MySQL - Update all values in a column using the equivalent of the PHP function ucfirst

To update all values in a column and change the first character to uppercase use the SQL query below.

Replace 'table' and 'column' with your data.

UPDATE table SET `column` = CONCAT(UPPER(SUBSTRING(column, 1, 1)),SUBSTRING(column, 2))

MySQL

ucfirst