UPDATE `postmeta`
SET meta_value = CAST(meta_value AS DECIMAL(10, 2)) * 1.25
WHERE meta_key IN('_sale_price', '_price', '_regular_price') AND meta_value > 0;
Omer KAYA – Senior Blazor Developer
Software Developer
UPDATE `postmeta`
SET meta_value = CAST(meta_value AS DECIMAL(10, 2)) * 1.25
WHERE meta_key IN('_sale_price', '_price', '_regular_price') AND meta_value > 0;