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)