LIKE, BETWEEN and IN Operators

LIKE — Pattern Matching

LIKE searches text patterns using wildcards: % (any characters) and _ (one character).

SELECT * FROM students WHERE name LIKE 'A%';   -- starts with A
SELECT * FROM students WHERE name LIKE '%kumar'; -- ends with kumar
SELECT * FROM students WHERE name LIKE '_a%';    -- 2nd letter a

BETWEEN — Range

SELECT * FROM students WHERE marks BETWEEN 60 AND 80;

IN — Match a List

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

Shorter than writing many OR conditions.

Summary

• LIKE = pattern match (% many, _ one).
• BETWEEN = inclusive range; IN = match any value in a list.

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।