I am looking for the correct way to retrieve the last 25 records from a dataset without having to first retrieve the entire dataset to pull out the last 25.
The potential dataset can be very large... 10,000 records that match the query... yet I only can use the most recent 25.
my first idea is:
SELECT *
FROM table
WHERE thisField=thatValue etc...
ORDER BY table_id DESC
LIMIT 25
But I'm not confident in this and looking for a yeah or nay from a guru or two or three.
Thanks,
Brian