Multi-column UPDATE

Update several columns in one UPDATE.

Update with WHERE

With WHERE you filter which rows to update. All matching rows change.

UPDATE products
SET category = 'indirim'
WHERE price < 10;

This query sets category to 'sale' for all products cheaper than 10.

In products, category = 'indirim' is updated. Only the rows where price < 10 holds are affected.

WHERE can update many rows at once. Write the condition carefully; a wrong condition makes unwanted changes.

Set category to 'sale' for products cheaper than 10 in products.

Show example solution

UPDATE products
SET category = 'indirim'
WHERE price < 10

Conditional update

UPDATE products
SET category = 'indirim'
WHERE ____;

Show answer

UPDATE products
SET category = 'indirim'
WHERE price < 10;