/*SELECT *
FROM m_product_catalog_preparation WHERE product_code IN('NK02','NK03','JYH05') AND catalog_code ='K0069';
*/

--BEGIN;
UPDATE m_product_catalog_preparation SET product_catalog_code ='NK02NP' WHERE product_catalog_code = 'NK02RP' AND catalog_code ='K0069' AND product_code ='NK02';
UPDATE m_product_catalog_preparation SET product_catalog_code ='NK03NP' WHERE product_catalog_code = 'NK03R' AND catalog_code ='K0069' AND product_code ='NK03';
UPDATE m_product_catalog_preparation SET product_catalog_code ='JYH05' WHERE product_catalog_code = 'JYH05R' AND catalog_code ='K0069' AND product_code ='JYH05';

--END