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”

My rsync Command

Ok so I started out using rsync with the options ‘-a –progress –delete’ and I thought that was doin’ the job just fine. But recently I migrated our old 600mhz Dell Optiplex GX110 to a Sans Digital MobileNAS MN2L dual drive RAID NAS and the rsyncs weren’t going as planned.

Rsync Screenie

Continue reading “My rsync Command”

The REAL Way to Change Lost Passwords in Ubuntu

If you lose any of your user passwords – including root you can change your password booting into single user mode. What you aren’t likely to find off the bat is the proper instructions to do it. They are out there, but chances are you will have to dig a little after some frustration. The main differece between all those super simple solutions and the one mentioned here is that you need to remount the OS drive in order to properly write your changes. This method has worked with the last three major releases of Ubuntu including Feisty. So, here’s the procedure…

Continue reading “The REAL Way to Change Lost Passwords in Ubuntu”