mysql 날짜검색시 between 안에 포함되는 날짜전체 출력

select a.Date 

from (

    select curdate() - INTERVAL (a.a + (10 * b.a) + (100 * c.a)) DAY as Date

    from (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as a

    cross join (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as b

    cross join (select 0 as a union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as c

) a

where a.Date between '2017-04-01' and '2017-04-30' 

/* between의 날짜는 오늘날짜에서 1000일 이내어야 함. */