4.5 IN, BETWEEN आणि LIKE — खरे फिल्टर्स

By Ravindra Bagale Last updated: 31 October 2026

का (Why). यादी, रेंज आणि पॅटर्न बहुतेक analyst filters कव्हर करतात.

काय (What). IN मूल्यांची यादी. BETWEEN समावेशक रेंज. LIKE मध्ये % (काहीही) आणि _ (एक अक्षर).

कसं (How). WHERE city IN ('Pune','Mumbai') / amount BETWEEN 500 AND 900 / name LIKE 'A%'

पायऱ्या

उदाहरण 1 · dataset: raja_coffee

SELECT order_id, city, amount_inr
FROM orders
WHERE city IN ('Pune','Goa')
  AND amount_inr BETWEEN 600 AND 1000;

Output

Meaning. पुणे किंवा गोवा, मध्यम रकमा.

उदाहरण 2 · dataset: raja_coffee

SELECT name, city FROM customers WHERE name LIKE 'P%';

Output

name	city
Priya Deshmukh	Kolhapur

Meaning. P ने सुरू होणारी नावे (Priya पॅटर्न).

Ravindra Bagale's Tip

BETWEEN is inclusive on both ends — 600 and 1000 both qualify.