Msg#: 4161100 posted 5:50 am on Jun 29, 2010 (gmt 0)
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.