MyBB Community Forums

MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.6 > 1.6 General Support > Need MYSQL query which will reset all signatures of users who has less than 5 posts
Full Version: Need MYSQL query which will reset all signatures of users who has less than 5 posts
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

MonsterMMORPG

2011-10-09, 09:00 PM
Hello. I need a MYSQL query which will reset all signatures of users who has less than 5 posts.

Thank you.

Paul H.

2011-10-09, 09:05 PM
UPDATE mybb_users SET signature = '' WHERE postnum < 5
MyBB Community Forums > Community Archive > Archived Forums > Archived Development and Support > MyBB 1.6 > 1.6 General Support > Need MYSQL query which will reset all signatures of users who has less than 5 posts