MariaDB- sql 쿼리문 (일간/주간/월간/연간) 게시글 출력

sql 쿼리문 (일간/주간/월간/연간) 게시글 출력

Ex)

(추천수 + 조회수) 베스트 글 출력시 각 sql 쿼리문 뒤에 ORDER BY 구문에 (추천수컬럼+조회수컬럼) 추가 후 

Limit 구문을 넣어 베스트 게시글 출력

 

Ex) 베스트 게시글 5개 출력

SELECT 날짜컬럼 FROM 테이블명 WHERE 날짜컬럼 BETWEEN DATE_ADD(NOW(), INTERVAL -1 DAY) 
AND NOW() ORDER BY (추천수컬럼+조회수컬럼) Limit 0, 5

 

일간 게시글  출력

SELECT 날짜컬럼 FROM 테이블명 WHERE 날짜컬럼 BETWEEN DATE_ADD(NOW(), INTERVAL -1 DAY) 
AND NOW() ORDER BY `정렬 컬럼`

 

Ex)

SELECT bdate FROM board WHERE bdate BETWEEN DATE_ADD(NOW(), INTERVAL -1 DAY) 
AND NOW() ORDER BY bdate

결과

 

주간 게시글 출력

SELECT 날짜컬럼 FROM 테이블명 WHERE 날짜컬럼 BETWEEN DATE_ADD(NOW(), INTERVAL -1 WEEK) 
AND NOW() ORDER BY `정렬 컬럼`

 

EX)

SELECT bdate FROM board WHERE bdate between date_add(NOW(),interval -1 WEEK) 
AND NOW() ORDER BY bno;

 

결과

 

월간 게시글 출력

SELECT 날짜컬럼 FROM 테이블명 WHERE 날짜컬럼 BETWEEN DATE_ADD(NOW(), INTERVAL -1 MONTH) 
AND NOW() ORDER BY `정렬 컬럼`

 

Ex)

SELECT bdate FROM board WHERE bdate BETWEEN DATE_ADD(NOW(), INTERVAL -1 MONTH) 
AND NOW() ORDER BY bdate

결과

 

연간 게시글 출력

SELECT 날짜컬럼 FROM 테이블명 WHERE 날짜컬럼 BETWEEN DATE_ADD(NOW(), INTERVAL -1 YEAR) 
AND NOW() ORDER BY `정렬 컬럼`

 

Ex)

SELECT bdate FROM board WHERE bdate BETWEEN DATE_ADD(NOW(), INTERVAL -1 YEAR) 
AND NOW() ORDER BY bdate

결과