«
»

Early morning SQLite

I hope I don’t regret this later:

sqlite> delete from messages
  where mailbox =
    (select ROWID from mailboxes where url = "local:///ARCHIVE06")
  and message_id in
    (select message_id from messages where mailbox =
      (select ROWID from mailboxes
         where url = "imap://bjepson@remote mailbox/ARCHIVE06"));

This entry was posted on Monday, August 6th, 2007 at 7:48 am and is filed under hacks. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply