MySQL 0000-00-00 00:00:00 맨뒤로 정렬

1 개요

MySQL 0000-00-00 00:00:00 맨뒤로 정렬

• 데이터 예시

mysql> SELECT * FROM free;
+----+---------+------------+---------------------+
| id | subject | content    | created             |
+----+---------+------------+---------------------+
|  1 | 안녕    | 하세요     | 0000-00-00 00:00:00 |
|  2 | 안녕2   | 하세요2    | 0000-00-00 00:00:00 |
|  3 | 반갑    | 습니다     | 2016-03-18 13:00:00 |
|  4 | 반갑2   | 습니다2    | 2016-03-18 14:00:00 |
+----+---------+------------+---------------------+
4 rows in set (0.00 sec)

• 0000-00-00 00:00:00 을 맨뒤로 정렬

mysql> SELECT * FROM free ORDER BY CASE WHEN created = '0000-00-00 00:00:00' THEN 2 ELSE 1 END, created;
+----+---------+------------+---------------------+
| id | subject | content    | created             |
+----+---------+------------+---------------------+
|  3 | 반갑    | 습니다     | 2016-03-18 13:00:00 |
|  4 | 반갑2   | 습니다2    | 2016-03-18 14:00:00 |
|  1 | 안녕    | 하세요     | 0000-00-00 00:00:00 |
|  2 | 안녕2   | 하세요2    | 0000-00-00 00:00:00 |
+----+---------+------------+---------------------+
4 rows in set (0.00 sec)

2 같이 보기

• 0000-00-00 00:00:00

3 참고

• http://stackoverflow.com/questions/9319553/mysql-order-by-with-empty-date-0000-00-00-as-last-but-the-rest-asc