SQL

/* Add $.08 to all USPS Domestic First-Class Rates */
UPDATE `weight_zone_service_domestic` 
SET shipping_cost = (shipping_cost + .08)
WHERE `service` LIKE  '1'
AND service_name LIKE  '%First-Class%';

/* Raise minimum to $2.75 for all USPS Domestic First-Class Rates */
UPDATE `weight_zone_service_domestic` 
SET shipping_cost = 2.75
WHERE shipping_cost < 2.75
AND `service` LIKE  '1'
AND service_name LIKE  '%First-Class%';

/* Add $.20 to all USPS Domestic Priority Mail Rates */
UPDATE `weight_zone_service_domestic` 
SET shipping_cost = (shipping_cost + .20)
WHERE `service` LIKE  '1'
AND service_name LIKE  '%Priority%';

/* Add $.45 to all USPS International (Non-Canada) First-Class Mail Rates */
UPDATE `weight_service_international`
SET shipping_cost = (shipping_cost + .45)
WHERE `service` = '1'
AND service_name LIKE '%First-Class%'
AND excluding_canada = '1';

/* Add $6.39 to all USPS International (Non-Canada) Priority Mail Rates */
UPDATE `weight_service_international`
SET shipping_cost = (shipping_cost + 6.39)
WHERE `service` = '1'
AND service_name LIKE '%Priority%'
AND excluding_canada = '1';

/* Add $3.00 to all USPS International (Canada) Priority Mail Rates */
UPDATE `weight_service_international`
SET shipping_cost = (shipping_cost + 3.00)
WHERE `service` = '1'
AND service_name LIKE '%Priority%'
AND excluding_canada = '0';

/* Add $.37 to all USPS International (Canada) First-Class Mail Rates */
UPDATE `weight_service_international`
SET shipping_cost = (shipping_cost + .37)
WHERE service = '1' AND service_name LIKE '%USPS First-Class%'
AND excluding_canada = '0'