MyBB Community Forums
Delete all user notes in ACP - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: General Support (https://community.mybb.com/forum-176.html)
+--- Thread: Delete all user notes in ACP (/thread-185768.html)



Delete all user notes in ACP - amanda_2011 - 10-28-2015

How do I go about deleting ALL user notes in ACP/Edit User/Moderator Options/User Notes for all my members? I want to delete them as a security measure. I'd prefer deleting them all at once instead of doing it one member at a time.

Thanks!


RE: Delete all user notes in ACP - Nathan Malcolm - 10-28-2015

UPDATE mybb_users SET usernotes = '';

That should be the query you're looking for. Make sure you take a backup beforehand incase something goes wrong. Smile


RE: Delete all user notes in ACP - amanda_2011 - 10-28-2015

I'll give that a try. Thank you!

ETA: Worked perfectly! Big Grin