CRUD Operations
The WHERE Clause
Filtering Rows
💡 WHERE, clause, EK, "FILTER" hai — SAARE, results, mein, se, SIRF, WOHI, rows, select, karta hai, JO, EK, SPECIFIC, CONDITION, satisfy, karti, hain, JAISE, EK, coffee, shop, mein, "SIRF, SIZE, LARGE, orders" filter, karna.
WHERE, comparison, operators, (=, >, <, !=), logical, operators, (AND, OR, NOT), aur, SPECIAL, operators, (LIKE, BETWEEN, IN, IS NULL) ke, saath, USE, hota hai.
LIKE, pattern, matching, ke, liye, hai — % (ANY, characters) aur, _ (SINGLE, character) wildcards, ke, saath. IN, MULTIPLE, VALUES, ki, LIST, se, MATCH, karta hai.
SELECT * FROM users WHERE age BETWEEN 18 AND 65;
SELECT * FROM users WHERE name LIKE 'A%'; -- "A" se, shuru, hone, waale
SELECT * FROM users WHERE status IN ('active', 'pending');
SELECT * FROM users WHERE deleted_at IS NULL;🎯
WHERE, clause, EK, "FILTER" hai — SAARE, results, mein, se, SIRF, WOHI, rows, select, karta hai, JO, EK, SPECIFIC, CONDITION, satisfy, karti, hain, JAISE, EK, coffee, shop, mein, "SIRF, SIZE, LARGE, orders" filter, karna.
1 / 2
⚡ झट से Recap
- WHERE = rows, ko, filter, karta hai, ek, condition, ke, basis, PAR
- LIKE = pattern matching (%, _ wildcards). IN = multiple values, se, match
- NULL checks, ke, liye, IS NULL/IS NOT NULL, use, karo, = nahi
इस page में (2 subtopics)
NOT, operator, se, EK, condition, ko, NEGATE, kiya, ja, sakta hai — NOT (condition1 AND condition2), se, complex, negations, EXPRESS, ki, ja, sakti, HAIN.
SELECT * FROM products WHERE NOT (category = 'electronics' AND price > 1000);Jab, AND, aur, OR, DONO, EK, saath, use, hote, hain, PARENTHESES, se, EXPLICIT, PRECEDENCE, SPECIFY, karna, CHAHIYE — MySQL, mein, AND, ki, PRECEDENCE, OR, se, ZYAADA, hai, JO, CONFUSING, results, de, sakta hai agar, PARENTHESES, na, ho.
Common Mistake: WHERE a = 1 OR b = 2 AND c = 3, EXPECTED, se, DIFFERENT, RESULT, de, sakta hai — HAMESHA, EXPLICIT, parentheses, use, karo, jab, AND/OR, DONO, ek, saath, ho.