[mysql] 기간내 월요일의 필드 정보 구하기 채택완료
g5_member 테이블에서 2020-10-28 ~ 2021-11-30 && mb_1 = 1 && mb_datetime = 월요일 를 count 하려고 합니다 아래와 같이 쿼리를 구현했는데, 원하는 값이 표시되지 않습니다 무언가 잘못 생각한 것이 있을듯 한데,,, 어디를 수정해야할까요? select WEEKDAY(SUBSTRING(mb_datetime,1,10)) as weekday_date, count(mb_1) as cnt from `g5_member` where mb_1='1' and mb_datetime between '2020-10-28 00:00:00' and '2021-11-30 23:59:59' and weekday_date='0' group by weekday_date
댓글을 작성하려면 로그인이 필요합니다.
답변 2개
채택된 답변
+20 포인트
sinbi4년 전
제 생각엔 여기가 문제 같아요.
수정 전: and weekday_date='0'
수정 후: and WEEKDAY(mb_datetime) = '0'
로그인 후 평가할 수 있습니다
답변에 대한 댓글 1개
댓글을 작성하려면 로그인이 필요합니다.
넓은마인드4년 전
</p>
<pre contenteditable="true">
<a href="<a href="https://dev.mysql.com/doc/refman/8.0/en/select.html" target="_blank" rel="noopener noreferrer">https://dev.mysql.com/doc/refman/8.0/en/select.html</a>" rel="noreferrer noopener" target="_blank">select</a> <a href="<a href="https://dev.mysql.com/doc/refman/8.0/en/group-by-functions.html#function_count" target="_blank" rel="noopener noreferrer">https://dev.mysql.com/doc/refman/8.0/en/group-by-functions.html#function_count</a>" rel="noreferrer noopener" target="_blank">count</a>(*) <a rel="noreferrer noopener" target="_blank">from</a> <a href="<a href="http://www.nobleweb.kr/adminer.php?username=woejd153&db=woejd153&table=g5_member" target="_blank" rel="noopener noreferrer">http://www.nobleweb.kr/adminer.php?username=woejd153&db=woejd153&table=g5_member</a>">g5_member</a> <a rel="noreferrer noopener" target="_blank">where</a> <a href="<a href="https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_dayofweek" target="_blank" rel="noopener noreferrer">https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_dayofweek</a>" rel="noreferrer noopener" target="_blank">DAYOFWEEK</a>(mb_datetime) = 2 <a href="<a href="https://dev.mysql.com/doc/refman/8.0/en/logical-operators.html#operator_and" target="_blank" rel="noopener noreferrer">https://dev.mysql.com/doc/refman/8.0/en/logical-operators.html#operator_and</a>" rel="noreferrer noopener" target="_blank">and</a> mb_datetime <a href="<a href="https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html#function_between" target="_blank" rel="noopener noreferrer">https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html#function_between</a>" rel="noreferrer noopener" target="_blank">between</a> '2020-10-28 00:00:00' <a href="<a href="https://dev.mysql.com/doc/refman/8.0/en/logical-operators.html#operator_and" target="_blank" rel="noopener noreferrer">https://dev.mysql.com/doc/refman/8.0/en/logical-operators.html#operator_and</a>" rel="noreferrer noopener" target="_blank">and</a> '2021-11-30 23:59:59' </pre>
<p>
이렇게 해보세요
로그인 후 평가할 수 있습니다
답변에 대한 댓글 1개
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인전체 질문 목록
채택
답변대기
답변대기
채택
답변대기