As it reduces the overhead caused by db_processing
some thing like this
UPDATE products
SET price =
CASE
WHEN category_id = 1 THEN 19.99
WHEN category_id = 2 THEN 24.99
ELSE 14.99 -- Default value if no condition matches
END
WHERE supplier_id = 5; -- Filter condition