SQLize Online / PHPize Online  /  SQLtest Online

-- Hint: use Ctrl+Enter for SQL autocomplete CREATE TABLE `products` ( `price` double, `price_z` double, `date_price` date DEFAULT (CURRENT_DATE) ); INSERT INTO `products` (`price`, `price_z`) VALUES (100, 1), (100, 100001), (100, 200001), (100, 300001); UPDATE `products` SET `price` = ROUND((`price_z` / 100) * ( CASE WHEN `price_z` BETWEEN 1 AND 100000 THEN 110 WHEN `price_z` BETWEEN 100001 AND 200000 THEN 109 WHEN `price_z` BETWEEN 200001 AND 300000 THEN 108 ELSE 107 END )) WHERE `date_price` = CURDATE(); SELECT * FROM `products`;