Suggest an editImprove this articleRefine the answer for “What does the BETWEEN operator do?”. Your changes go to moderation before they’re published.Approval requiredContentWhat you’re changing🇺🇸EN🇺🇦UAPreviewTitle (EN)Short answer (EN)`BETWEEN` is an operator that filters data by a range of values: it checks whether a value falls between two bounds, inclusive, e.g. `WHERE age BETWEEN 18 AND 30`. **Key point:** it works with numbers, dates, and text, and the range's bounds are included in the result.Shown above the full answer for quick recall.Answer (EN)Image`BETWEEN` is an operator that filters data by a range of values. It checks whether a value falls **between two bounds**, inclusive. Syntax: ```sql WHERE column BETWEEN value1 AND value2 ``` Examples: - `WHERE age BETWEEN 18 AND 30`, selects every row where age is between 18 and 30, inclusive. - `WHERE date BETWEEN '2025-01-01' AND '2025-12-31'`, selects every record from the year 2025. Important: - It works with numbers, dates, and text. - The range's bounds **are included** in the result.For the reviewerNote to the moderator (optional)Visible only to the moderator. Helps review go faster.