Re: how to retrieve specific number of rows

[Felix Geerinckx]

ibakebread wrote:

> Just a way to retrieve all but the five most recent entries.

'most recent' implies you have a DATETIME or TIMESTAMP column in your table. Let's assume it is t.ts

SELECT * FROM t ORDER BY ts LIMIT 5, 10000000;

where 10000000 is a suitable large integer, at least as large as the number of records in your table.

--
felix
Please use BBCode to format your messages in this forum.