check if date is between two dates column in mysql code example

Example: mysql curdate between two dates

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