Update all values of a column to lowercase

By | 26th February 2017

Update all values of a column to lowercase
Mysql LOWER function is used to update field in lowercase.

UPDATE table_name SET fieldname = LOWER(fieldname)

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

Leave a Reply

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