Anonymous

mysql> select date,category from sms_toto where date like '2012-04-01%' order by date desc;
+---------------------+----------+
| date                | category |
+---------------------+----------+
| 2012-04-01 05:16:55 | t3d      |
| 2012-04-01 05:16:55 | 8to3d    |
| 2012-04-01 05:14:34 | t56      |
| 2012-04-01 05:14:34 | 8to56    |
| 2012-04-01 05:03:08 | 8MPT     |
| 2012-04-01 05:03:08 | 8TOT     |
| 2012-04-01 05:03:08 | POR      |
| 2012-04-01 05:03:08 | POT      |
| 2012-04-01 05:03:08 | MPT      |
| 2012-04-01 05:03:08 | TOT      |
| 2012-04-01 04:59:02 | pmp      |
| 2012-04-01 04:59:02 | mpt      |
| 2012-04-01 04:59:02 | POD      |
| 2012-04-01 04:59:02 | POR      |
| 2012-04-01 04:59:02 | 8pmp     |
| 2012-04-01 04:59:02 | 8mpt     |
| 2012-04-01 04:54:00 | scs      |
| 2012-04-01 04:54:00 | POW      |
| 2012-04-01 04:54:00 | 8scs     |
| 2012-04-01 04:47:38 | 8l4d     |
| 2012-04-01 04:47:38 | pos      |
| 2012-04-01 04:47:38 | l4d      |
| 2012-04-01 04:44:01 | l3d      |
| 2012-04-01 04:44:01 | 8l3d     |
| 2012-04-01 04:39:16 | 8MPT     |
| 2012-04-01 04:39:16 | 8MGM     |
| 2012-04-01 04:39:16 | POR      |
| 2012-04-01 04:39:16 | POM      |
| 2012-04-01 04:39:16 | mpt      |
| 2012-04-01 04:39:16 | mgm      |
| 2012-04-01 04:34:34 | stc      |
| 2012-04-01 04:34:34 | 8stc     |
+---------------------+----------+
32 rows in set (0.02 sec)