[mysql] 오늘부터 5일 전까지 5개 조회

 
SELECT * FROM TABLE#1 
	where 1=1
	and column#0 = 4
	and date(DATE_FORMAT(concat(column#1,column#2,column#3),'%Y%m%d')) >= date(subdate(now(), INTERVAL 3 DAY))
	and date(DATE_FORMAT(concat(column#1,column#2,column#3),'%Y%m%d')) <= date(now())
	order by date(DATE_FORMAT(concat(column#1,column#2,column#3),'%Y%m%d')) ASC
	limit 5;