Delete all but the newest 100 records?

[Brian Dunning]

I'd like to delete all but the newest 100 records from a table. I  
have a timestamp field. I can't figure out how to do this in a single  
SQL statement - can anyone help? Thanks!

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]