https://rt-wiki.bestpractical.com/index.php?action=history&feed=atom&title=AttachmentsSizeSQLAttachmentsSizeSQL - Revision history2026-08-22T00:01:44ZRevision history for this page on the wikiMediaWiki 1.41.1https://rt-wiki.bestpractical.com/index.php?title=AttachmentsSizeSQL&diff=219&oldid=prevAdmin: 2 revisions imported2016-04-06T20:03:16Z<p>2 revisions imported</p>
<p><b>New page</b></p><div>Found on my disk SQL that fetches attachments sizes from RT DB. It's not that trivial as we store it in headers. May be someone would find this useful. Works with mysql 4.1.x --[[RuslanZakirov]]<br />
<br />
SELECT id, IF(<br />
LOCATE('Content-Length:', Headers),<br />
CAST(TRIM(<br />
SUBSTRING_INDEX(<br />
SUBSTRING_INDEX(Headers, 'Content-Length:', -1),<br />
"\n",<br />
1<br />
)<br />
) AS UNSIGNED INTEGER),<br />
BINARY LENGTH(Content)<br />
) ContentLength<br />
FROM Attachments;</div>Admin