I'm a little skittish when it comes to using an SQL query to attempt this and I'm not sure I fully understand some of the ways this can be manipulated through the admin console (if in fact it can be done) name/value manager. I'm looking to see if there is a way to mass change/update the Product Shipping Weight is some fashion. Whether it's by category ID or some other means which I can then go back in and manually change the odd item here and there.

Any help appreciated.