MySQL Tutorial - WHERE - Filter Data
🔎 WHERE - Filter Karo
Real Life Filters:
🛒 Price < 1000
👥 Age >= 18
📊 Stock > 0
📅 Date = today
Operators
| Operator | Meaning |
|---|---|
| = | Equal |
| != | Not equal |
| > | Greater than |
| < | Less than |
| AND | Both true |
| OR | Either true |
| LIKE | Pattern match |
Example
SELECT * FROM products
WHERE price > 1000 AND stock > 0;