Cheat Sheet logoCheat Sheet Today
SQLite CRUD and SELECT Cheatsheet/Delete matching rows

Remove records by condition.

Back to sheetBrowse commands
Sign in to save
Section: Insert, update, delete, and upsert

Delete matching rows

sql
sql
DELETE FROM sessions WHERE expires_at < CURRENT_TIMESTAMP;
Explanation

A common cleanup pattern for caches, sessions, and temporary records.

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, delete, and upsert
Insert one row
Add a new record.
OpenIn sheetsqlsame section
Insert multiple rows
Add several records in one statement.
OpenIn sheetsqlsame section
Update matching rows
Modify one or more records.
OpenIn sheetsqlsame section
Upsert with ON CONFLICT
Insert or update on a uniqueness collision.
OpenIn sheetsqlsame section
Ignore duplicates on conflict
Keep the existing row when a unique key collides.
OpenIn sheetsqlsame section
Select all columns
Read rows from a table.
OpenIn sheetsql1 tag match