Need to update the uc_products database to change all weights in ounces to weights in pounds (to work properly with a third-party postage calculator).
Should find any rows where weight_units is currently "oz" and convert the weight to pounds rounded to one decimal place (and change weight_units to "lb").
Any help constructing this query greatly appreciated! Don't want to trash my entire uc_products table with the wrong code... 