Monthly Archives: February 2017

Update all values of a column to Upper case

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 );

Update all values of a column to lowercase

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 );