Update all values of a column to Upper case

By | 26th February 2017

Update all values of a column to upper case
Mysql UPPER function is used to update field in uppercase.

UPDATE table_name SET fieldname = UPPER(fieldname)

example :
UPDATE member SET first_name = UPPER( first_name );

Leave a Reply

Your e-mail address will not be published. Required fields are marked *