UPDATE with WHERE Clause

The WHERE clause in an UPDATE statement is critical. It determines exactly which rows will be modified. Omitting the WHERE clause causes every row in the table to be updated — a common and costly mistake.

Filtering with WHERE

The WHERE clause supports all the same operators as in a SELECT statement: comparison operators (=, !=, <, >), logical operators (AND, OR, NOT), range checks (BETWEEN), and list membership (IN). This flexibility lets you target rows with precision.

When writing the WHERE clause, think about the minimum set of conditions needed to uniquely identify the rows you want to change. Using a primary key is the safest approach for single-row updates.

Examples of WHERE Conditions

WHERE id = 5 — single row by primary key
WHERE status = 'pending' — all pending orders
WHERE price > 100 AND category = 'electronics' — filtered set
WHERE country IN ('US', 'CA') — multiple countries

Always wrap sensitive UPDATE statements in a transaction so you can roll back if something goes wrong.

Example

-- Update only active users in a specific country
UPDATE users
SET is_verified = 1
WHERE country = 'Norway'
  AND is_active = 1
  AND registered_at < '2024-01-01';

SQL

Full Editor

Pro Tip

Use BEGIN / ROLLBACK to safely test UPDATE statements before committing.

Related Resources

MySQL Reference

Complete tag & property list

MySQL How-To Guides

Step-by-step practical guides

MySQL Exercises

Practice what you've learned