Hi, I hoped you will do some leg work and figure this out.
On Thu, Jan 17, 2013 at 5:35 PM, Remy van Elst <[email protected]> wrote: > Hy Rus, > > Tried some more stuff, now it is working. Thanks! > > The Query: > > mysql> SELECT DISTINCT Transactions.ObjectId,Attachments.Subject FROM > Attachments LEFT OUTER JOIN Transactions ON Transactions.Id = > Attachments.TransactionId WHERE Transactions.ObjectType = 'RT::Ticket' > AND LENGTH(Attachments.Content) > 4000000; > > Written it down for other people who might have the same problem: > > https://raymii.org/s/tutorials/RT_find__and_delete_big_attachments.html > > Sincerely, -- Best regards, Ruslan.
