mysql> select date,category from sms_toto where date like '2012-03-31%' order by date desc; +---------------------+----------+ | date | category | +---------------------+----------+ | 2012-03-31 21:07:13 | t3d | | 2012-03-31 21:07:13 | 8to3d | | 2012-03-31 21:07:09 | t56 | | 2012-03-31 21:07:09 | 8to56 | | 2012-03-31 21:07:04 | 8MPT | | 2012-03-31 21:07:04 | 8TOT | | 2012-03-31 21:07:04 | POR | | 2012-03-31 21:07:04 | POT | | 2012-03-31 21:07:04 | MPT | | 2012-03-31 21:07:04 | TOT | | 2012-03-31 21:07:00 | scs | | 2012-03-31 21:07:00 | POW | | 2012-03-31 21:07:00 | 8scs | | 2012-03-31 21:06:55 | stc | | 2012-03-31 21:06:55 | 8stc | | 2012-03-31 21:06:51 | l4d | | 2012-03-31 21:06:51 | pos | | 2012-03-31 21:06:51 | 8l4d | | 2012-03-31 21:06:44 | l3d | | 2012-03-31 21:06:44 | 8l3d | | 2012-03-31 21:06:39 | 8mpt | | 2012-03-31 21:06:39 | 8pmp | | 2012-03-31 21:06:39 | POR | | 2012-03-31 21:06:39 | POD | | 2012-03-31 21:06:39 | mpt | | 2012-03-31 21:06:39 | pmp | | 2012-03-31 21:06:30 | mgm | | 2012-03-31 21:06:30 | mpt | | 2012-03-31 21:06:30 | POM | | 2012-03-31 21:06:30 | POR | | 2012-03-31 21:06:30 | 8MGM | | 2012-03-31 21:06:30 | 8MPT | +---------------------+----------+ 32 rows in set (0.03 sec) mysql>