[MYSQL]그룹을 연속 된 날짜로 출력

 

#DB데이터
SELECT NAME3,NAME10,NAME11,NAME12,NAME13 FROM CHECK_VACATION_V2
      WHERE NAME13 NOT REGEXP '반차|외근'
ORDER BY NAME3 ASC

 

#DB조회결과

SELECT t.NAME3
       ,c.Numdate
       ,t.NAME12
       ,t.NAME13
FROM CHECK_VACATION_V2 t
     JOIN view_calendar c ON c.Numdate BETWEEN DATE_FORMAT(t.NAME10, '%Y-%m-%d') AND DATE_FORMAT(t.NAME11, '%Y-%m-%d')
WHERE NAME13 NOT REGEXP '반차|외근'
ORDER BY NAME3,c.Numdate ASC

 

=====================================================================

 

#참고쿼리

SELECT
     t.id, c.a_day
FROM
     t
     JOIN calendar c ON c.a_day BETWEEN t.start_date AND t.end_date 
ORDER BY
     t.id, c.a_day ;