To update all records to upper case

If you want to update all records can use this sql statement

1
UPDATE staff SET `staff_name` = UPPER( `staff_name` )

Leave a Reply

Your email address will not be published. Required fields are marked *