How to select date between date range in SQL MySQL

How to select date between date range in SQL MySQL

April 30, 2018 0 By Abid

Suppose we have a table namely attendance.  If you  want to show data  till 4th April,  you can just use this sql query.

SELECT * from attendance where Date <‘2018-04-10’;