Check if the current date is between two dates + mysql select query

Solution:

Try this :: This will solve your problem

SELECT * FROM `table` WHERE active=0 AND CURDATE() between dateStart and dateEnd