[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개
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인전체 질문 목록
채택
답변대기
답변대기
답변대기
채택
채택
답변대기
답변대기
답변대기
답변대기
답변대기
답변대기
채택
답변대기
채택
채택
답변대기
답변대기
답변대기