mysql query 특정 날짜 데이터 뽑아내기.

$query = "SELECT user_id, SUM(1) CNT, qdate AS regdate FROM Qna";
$query .= " WHERE qdate>=".strtotime($sday.' day');
$query .= "   AND qdate<".strtotime($eday.' day');
$query .= " GROUP BY user_id";
$query .= " ORDER BY CNT DESC";
$query .= ' LIMIT 20';

위에 것은 시간을 기준으로 된것 이고

http://blog.naver.com/dongheejo?Redirect=Log&logNo=60062482763

이것이 원하는 결과로 나옴.



월별, 주별 통계를 뽑을때

SELECT FROM_UNIXTIME(DATE, "%Y %m %U"), count(*) FROM Memo m
WHERE m.enabled='Y'
GROUP BY FROM_UNIXTIME(DATE, "%Y %m %U");

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_current-timestamp