Find Long SIGs

Steve Freides

Active member
I do not see a way, via user search or batch update, to identify all users whose current SIG file is longer than the currently allowed limit. There was a time when SIG file length was unlimited on our forum, and although our current limit is 250 characters, some are well over 1k long. I'd like to quantify and be able to reach out to all the "too long" people to see about getting them to bring their SIG into compliance with our current guidelines.

Thanks in advance for your replies.


XenForo moderator
Staff member
I'm not in my office so can't check but this query may work.

SELECT * FROM xf_user_profile WHERE CHAR_LENGTH(signature) > 250;