Cheat Sheet logoCheat Sheet Today
MySQL SELECT, INSERT, UPDATE, and DELETE Cheatsheet/Filter by date range

Return rows between two timestamps.

Back to sheetBrowse commands
Sign in to save
Section: basic selects

Filter by date range

sql
sql
SELECT id, created_at FROM orders WHERE created_at BETWEEN '2026-01-01' AND '2026-01-31 23:59:59';
Explanation

Use explicit endpoints to avoid off-by-one issues in reporting.

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 basic selects
Select all columns
Return all columns from a table.
OpenIn sheetsqlsame section
Select specific columns
Return only the columns you need.
OpenIn sheetsqlsame section
Filter rows with WHERE
Match rows using equality conditions.
OpenIn sheetsqlsame section
Sort and limit results
Return the newest rows first.
OpenIn sheetsqlsame section
Return distinct values
Collapse duplicates in a result set.
OpenIn sheetsqlsame section
Search using LIKE
Match a string using wildcard patterns.
OpenIn sheetsqlsame section