Return rows matching an exact value.
Section: Filtering Rows
Filter with equality
sql
sql
SELECT *
FROM users
WHERE status = 'active';Explanation
Use WHERE to limit the result set before grouping or ordering.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing Filtering Rows