Discussion in 'XenForo Questions and Support' started by Mr Lucky, Jul 3, 2014.
I'd like to search for posts by size. Is this possible? Any addons that might do it?
You can use the Minimum Number of Replies option.
Or do you mean actual post size based on content?
I mean actual size of the post content.
There are some very old posts that I'd like to convert to xenzine Articles or CTA Featured Threads. All I can remember is that they are very large. I can't even remember what they are about, so searching for big posts would help me find them.
You'd have to do it in the DB directly:
SELECT post_id, thread_id, message FROM xf_post ORDER BY LENGTH(message) DESC LIMIT 20;
Separate names with a comma.