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;