Good. Now, if you want to find users whose age is between 13 and 70, you can of course use the previous example:
SELECT id, name
WHERE age <= 70
AND age >= 13;
But there is also another way of writing the example above. Take a look:
WHERE age BETWEEN 13 AND 70;
We introduced a new keyword
BETWEEN which simply means that we look for rows with the age column set to be anything between 13 and 70, including these values.
Note, however, that some database systems can produce different results – in some of them, the values 13 and 70 are not included in the results. Always check how
BETWEEN works in your database.