select count(1) from xx_table where status =1
and DATE_FORMAT(created_date,'%Y-%m-%d') >= DATE_FORMAT('2019-08-01','%Y-%m-%d')
and DATE_FORMAT(created_date,'%Y-%m-%d') <= DATE_FORMAT('2019-08-05','%Y-%m-%d')
select count(1) from xx_table where status =1
and DATE_FORMAT(created_date,'%Y-%m-%d') >= DATE_FORMAT('2019-08-01','%Y-%m-%d')
and DATE_FORMAT(created_date,'%Y-%m-%d') <= DATE_FORMAT('2019-08-05','%Y-%m-%d')