BETWEEN

The BETWEEN can be used in a case where we want to fetch records which comes under the certain range. This range can be any like text, dates or numbers. Suppose if we want to search users whose created date is between 1st July to 16th July, 2017 then below query can help us with the BETWEEN clause.

select * from users where created_at BETWEEN '2017-07-01 00:00:00' AND '2017-07-16 00:00:00';

Same way, we can also define the range in number to search users who belong to that particular range. Like if we want students whose marks are between 70 to 80 then BETWEEN can be used to define the range.