그누보드 MySQL 최신글 여부 조회

그누보드 MySQL 최신글 컬럼

1 확인

mysql> SELECT wr_id, wr_datetime FROM g5_write_free WHERE wr_is_comment=0 ORDER BY wr_datetime DESC LIMIT 5;
+-------+---------------------+
| wr_id | wr_datetime         |
+-------+---------------------+
|    87 | 2015-11-30 15:50:57 |
|    86 | 2015-11-30 09:42:41 |
|    85 | 2015-11-30 09:04:38 |
|    83 | 2015-11-18 13:29:48 |
|    82 | 2015-10-29 17:43:38 |
+-------+---------------------+
5 rows in set (0.00 sec)

2 최신글 컬럼 표시

mysql> SELECT wr_id, wr_datetime, (wr_datetime>SUBDATE(CURDATE(),14)) new FROM g5_write_free WHERE wr_is_comment=0 ORDER BY wr_datetime DESC LIMIT 5;
+-------+---------------------+------+
| wr_id | wr_datetime         | new  |
+-------+---------------------+------+
|    87 | 2015-11-30 15:50:57 |    1 |
|    86 | 2015-11-30 09:42:41 |    1 |
|    85 | 2015-11-30 09:04:38 |    1 |
|    83 | 2015-11-18 13:29:48 |    0 |
|    82 | 2015-10-29 17:43:38 |    0 |
+-------+---------------------+------+
5 rows in set (0.00 sec)

→ 14일 이내 글은 new 컬럼값을 1로 출력

3 같이 보기

• 그누보드 게시판 테이블