BETWEEN range filtering in MySQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the SQL BETWEEN operator do?

The BETWEEN operator filters results to include only values within a specified range, including the start and end values.

beginner

Write a simple SQL query using BETWEEN to find ages between 18 and 30.

Example: <br>SELECT * FROM users WHERE age BETWEEN 18 AND 30;<br>This returns users aged 18 through 30 inclusive.

beginner

Does BETWEEN include the boundary values in the range?

Yes, BETWEEN includes both the start and end values in the range.

intermediate

How is BETWEEN different from using >= and <=?

Using BETWEEN a AND b is the same as value >= a AND value <= b. BETWEEN is just a shorter, clearer way to write it.

beginner

Can BETWEEN be used with dates in MySQL?

Yes, BETWEEN works with dates to filter rows between two dates, including both dates.

Which of the following queries correctly selects rows where the price is between 100 and 200?

A SELECT * FROM products WHERE price BETWEEN 100 AND 200;

B SELECT * FROM products WHERE price > 100 AND price < 200;

C SELECT * FROM products WHERE price >= 100 OR price <= 200;

D SELECT * FROM products WHERE price = 100 AND price = 200;

BETWEEN 100 AND 200 includes prices from 100 to 200 inclusive. Option B excludes 100 and 200, C uses OR which is incorrect, and D is impossible.

Does BETWEEN include the boundary values in the range?

A It includes only the lower boundary.

B No, it excludes both boundaries.

C Yes, it includes both boundaries.

D It includes only the upper boundary.

BETWEEN always includes the start and end values.

Which is equivalent to value BETWEEN 10 AND 20?

A value = 10 OR value = 20

B value &gt; 10 AND value &lt; 20

C value &gt;= 10 OR value &lt;= 20

D value &gt;= 10 AND value &lt;= 20

BETWEEN includes both boundaries, so it equals >= 10 AND <= 20.

Can BETWEEN be used to filter date ranges in MySQL?

A No, it only works with numbers.

B Yes, it works with dates.

C Only with datetime, not date.

D Only with strings.

BETWEEN works with numbers, dates, and strings in MySQL.

What happens if you write WHERE value BETWEEN 20 AND 10?

A It returns no rows because the range is invalid.

B It returns all rows.

C It swaps the values automatically.

D It returns rows where value is between 10 and 20.

The BETWEEN operator expects the first value to be less than or equal to the second. If reversed, it returns no rows.

Explain how the BETWEEN operator works in SQL and give an example query.

Think about filtering values within a range.

Describe the difference between using BETWEEN and using >= and <= operators.

Consider how you write conditions for a range.