To update all records to upper case Leave a reply If you want to update all records can use this sql statement 1 UPDATE staff SET `staff_name` = UPPER( `staff_name` )UPDATE staff SET `staff_name` = UPPER( `staff_name` )