> I'd love to get the offset working if possible. Since offset is not in the supported syntax for deletes (see http://dev.mysql.com/doc/refman/5.0/en/delete.html), I think you'll have some trouble with that.
You could do something like this: SELECT @theDeadline := `timestamp` FROM `table` ORDER BY `timestamp` DESC LIMIT 100; DELETE FROM `table` WHERE `timestamp` < @theDeadline; It might not be quite perfect if certain critical records have the same timestamp, but it will work in most cases. -- Scott Noyes [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
