Python SQL WHERE Clause: Filtering Predicates & Comparison
The `WHERE` clause filters records by evaluating a boolean search condition (predicate) against each row in the source table. Only rows where the predicate evaluates to `TRUE` are passed to subsequent query stages. Rows evaluating to `FALSE` or `UNKNOWN` (due to NULLs) are discarded.
"The `WHERE` clause is a security bouncer at a club door: checking IDs against strict criteria and admitting only guests who meet the age and dress code rules."
Deep Dive: How It Works
Comparison Operators: `=` (equal), `<>` or `!=` (not equal), `<` (less than), `<=` (less or equal), `>` (greater than), `>=` (greater or equal).
Three-Valued Logic (3VL): In SQL, boolean conditions evaluate to `TRUE`, `FALSE`, or `UNKNOWN`. Comparing with NULL always yields `UNKNOWN`.
Index SARGability: Queries with clean comparison predicates on indexed columns (`WHERE age >= 21`) can perform fast binary index range scans.
Syntax Blueprint
SELECT column1, column2 FROM table_name WHERE condition_is_true;
The WHERE clause filters rows immediately after the FROM table is scanned.
Core Rules to Remember
Common Beginner Traps & How to Fix Them
Using double quotes around string values in standard SQL (`WHERE name = "Alice"`).Why it happens: In ANSI SQL and Postgres, double quotes denote identifier names (table/column), while single quotes denote string literals.
How to fix: Always wrap string literal values in single quotes: `WHERE name = 'Alice'`.
Live Interactive Example
Hit Run Code to see it liveYour Turn: Micro Challenge
No pressure! Edit the starter code below and test your solution with instant feedback.
Filter Products by Price
- Select `name` and `price` from `goods` where `price < 50.0`.
Finished reading and practicing?
Mark this lesson as completed to update your course progress.