MySQL: Convert all Values in Column to Upper Case

Recently using osCommerce I had a customer who wished to have all the products’ names in uppercase but they had been entered in mixed case. After having some trouble finding a simple answer through Google, I pieced together this simple query that can also be adapted to other situations.

 

The below is a MySQL query to update all of the products’ names in an osCommerce catalog to uppercase – you can copy this into phpMyAdmin.

UPDATE products_description SET `products_name` = UPPER( `products_name` )

OR GENERICALLY:

UPDATE table_name SET `column_name` = UPPER( `column_name` )

PhotoRec Saved My Butt

So my reckless typing really got me into trouble this time. I was attempting to zero-out a usb drive when I managed to put the wrong device in the dd command – I automatically typed sda1 (the primary HD) out of habit instead of sdb1 – the usb drive. I caught my mistake and gave it a solid control + c but I had still wiped out the first 60 MBs of the drive.

PhotoRec

Continue reading “PhotoRec Saved My Butt”