joined:May 12, 2007
I have a list of entries in my database where I always only use the most recent 100 entries. I successfully accomplish this with:
SELECT * FROM table WHERE something='stuff' ORDER BY field DESC LIMIT 100;
In order to begin cleaning up the data, is there a command that will delete the records beyond the initial 100? I can't just do
DELETE FROM table WHERE something='stuff' ORDER BY field DESC LIMIT 100;
because that will delete my first 100 records...i want record 101+ (from the queried results of course...not the whole table).
Also, i do not have a date field, so this is not deletion based upon a date range...just based upon result number.