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` )
UPDATE table_name SET `column_name` = UPPER( `column_name` )