Hi,
I currently use a SELECT that looks like:
SELECT field
FROM some_table
WHERE some_condition
ORDER BY some_date DESC
LIMIT 2000
in order to get the most recent records from some_table.
Since it is not possible (yet) to optimise an ORDER BY ... DESC
by using an index; is it possible to rewrite SELECT statement:
SELECT field
FROM some_table
WHERE some_condition
ORDER BY some_date
LIMIT ?????
so that results will be ordered in ascending order and return
the 2000 *last* records ?
Thanks
--
Joseph Bueno
NetClub/Trader.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php