You can add an offset in the Limit statement. Look at the Select Syntax in the docs.
There is an even simpler solution to this problem. Use your creation field within a Where clause instead of using Order by and Limit. -Dan I'm trying to delete all but the newest n records. DELETE FROM tablename ORDER BY creation DESC LIMIT=n This does the opposite of what I want. Is there some way to tell it to start the delete after n and delete all the remaining records?
