LIKE, BETWEEN और IN Operators

LIKE — Pattern Matching

LIKE wildcards से text patterns खोजता है: % (कोई भी characters) और _ (एक character)।

SELECT * FROM students WHERE name LIKE 'A%';   -- A से शुरू
SELECT * FROM students WHERE name LIKE '%kumar'; -- kumar से खत्म
SELECT * FROM students WHERE name LIKE '_a%';    -- दूसरा अक्षर a

BETWEEN — Range

SELECT * FROM students WHERE marks BETWEEN 60 AND 80;

IN — List से Match

SELECT * FROM students WHERE class IN ('9', '10', '11');

कई OR conditions लिखने से छोटा।

सारांश

• LIKE = pattern match (% कई, _ एक)।
• BETWEEN = inclusive range; IN = list में किसी value से match।