MyBB Community Forums

Full Version: Query to delete all posts by guests in specific forum
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
What will be the query to do that? The posts by guests are in FID 66, and it's like 500 and full of spam, how do I delete them all from that forum?

Thanks. Smile
Backup your database table first, then run this query;
DELETE FROM `mybb_posts` WHERE `fid` = 'X' AND `uid` = '0';

Replace mybb_ with your table prefix.
X = Forum ID from where you want to delete from Wink