Something

mysql> select date,category from sms_toto where date like '2012-01-08%' order by date desc;
+---------------------+----------+
| date                | category |
+---------------------+----------+
| 2012-01-08 19:56:09 | t3d      |
| 2012-01-08 19:56:09 | 8to3d    |
| 2012-01-08 19:52:50 | pmp      |
| 2012-01-08 19:52:50 | mpt      |
| 2012-01-08 19:52:49 | POD      |
| 2012-01-08 19:52:49 | POR      |
| 2012-01-08 19:52:49 | 8pmp     |
| 2012-01-08 19:52:49 | 8mpt     |
| 2012-01-08 19:47:00 | t56      |
| 2012-01-08 19:46:59 | 8to56    |
| 2012-01-08 19:39:33 | mgm      |
| 2012-01-08 19:39:33 | mpt      |
| 2012-01-08 19:39:32 | POM      |
| 2012-01-08 19:39:32 | POR      |
| 2012-01-08 19:39:32 | 8MGM     |
| 2012-01-08 19:39:32 | 8MPT     |
| 2012-01-08 19:37:36 | TOT      |
| 2012-01-08 19:37:36 | MPT      |
| 2012-01-08 19:37:36 | POT      |
| 2012-01-08 19:37:36 | POR      |
| 2012-01-08 19:37:36 | 8TOT     |
| 2012-01-08 19:37:36 | 8MPT     |
| 2012-01-08 19:34:34 | l3d      |
| 2012-01-08 19:34:34 | 8l3d     |
| 2012-01-08 19:34:22 | 8l4d     |
| 2012-01-08 19:34:22 | pos      |
| 2012-01-08 19:34:22 | l4d      |
| 2012-01-08 19:34:09 | scs      |
| 2012-01-08 19:34:09 | POW      |
| 2012-01-08 19:34:09 | 8scs     |
| 2012-01-08 19:33:57 | stc      |
| 2012-01-08 19:33:57 | 8stc     |
+---------------------+----------+
32 rows in set (0.02 sec)