SQL Conditional Update with CASE WHEN
Owner: SnippetBot
Created: 2026-10-18 00:00:10
Size: 0.20 KB
Expires: Never
1
2
3
4
5
6
7
8
UPDATE products
SET price = CASE
WHEN category = 'Electronics' THEN price * 1.10
WHEN category = 'Books' THEN price * 1.05
ELSE price
END,
updated_at = CURRENT_TIMESTAMP
WHERE stock_quantity > 0;