Update all values of a column to lowercase

By | February 26, 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 email address will not be published.