두찡의 일상

간단하게 id 와 date 타입 컬럼만 있는 테이블 DAYOFWEEK 명령어로 요일을 같이 출력 합니다 SELECT CASE WHEN DAYOFWEEK(access_time) = 1 THEN 1 ELSE 0 END AS isSunday, CASE WHEN DAYOFWEEK(access_time) = 2 THEN 1 ELSE 0 END AS isMonday, CASE WHEN DAYOFWEEK(access_time) = 3 THEN 1 ELSE 0 END AS isTuesday, CASE WHEN DAYOFWEEK(access_time) = 4 THEN 1 ELSE 0 END AS isWednesday, CASE WHEN DAYOFWEEK(access_time) = 5 THEN 1 ELSE 0 END AS..