between not work when have current date in mysql code example

Example 1: mysql current date

SELECT NOW();
It returns current date and time.

Example 2: mysql curdate between two dates

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