Cheat Sheet logoCheat Sheet Today
SQL DDL and DML/Update matching rows

Modify existing data using a WHERE clause.

Back to sheetBrowse commands
Sign in to save
Section: INSERT, UPDATE, and DELETE

Update matching rows

sql
sql
UPDATE users
SET status = 'inactive'
WHERE last_login_at < DATE '2024-01-01';
Explanation

Always confirm the WHERE clause before running UPDATE in production.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing INSERT, UPDATE, and DELETE
Insert one row
Add a single row to a table.
OpenIn sheetsqlsame section
Delete matching rows
Remove rows that match a condition.
OpenIn sheetsqlsame section
Merge or upsert data
Insert new rows and update existing ones in one logical operation.
OpenIn sheetsqlsame section
Insert multiple rows
Add several rows in one statement.
OpenIn sheetsqlsame section
Insert from select
Populate a table using query results.
OpenIn sheetsqlsame section
Create table
Define a new table with columns and constraints.
OpenIn sheetsql