If you post the table structure (SHOW CREATE TABLE tablename\G) we could help you write this statement.
Shawn Green Database Administrator Unimin Corporation - Spruce Pine Gerald Taylor <[EMAIL PROTECTED]> wrote on 11/10/2004 11:52:35 AM: > I have this table of events. Each event has an owner > id and the time that it happened. > > What I want to do is delete all events > more than three months old but only if the owner does not own > any newer events. > > The coolest would just be a single DELETE query. > > Can this be done? > Mysql 4.0.18 > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >
