MySQL SQL

MySQL BETWEEN

Filter values within an inclusive range.

SELECT * FROM products
WHERE price BETWEEN 500 AND 1000;

BETWEEN includes both boundary values. It can be used with numbers, dates, and text according to comparison rules.