Ah that makes sense. It's a double shot, first grabbing the
necessary records, then selecting all in that temp value (hitlist) in
reverse order.
Well done.
Cheers
On Jun 30, 2007, at 11:26 AM, Octavian Rasnita wrote:
Hi,
Try something like this:
select * from (select * from table_name where ... order by
last_update desc limit 10) as tbl order by tbl.last_update;
Rich in Toronto
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]