SQL to delete Topics (along with posts), where tag is like '%unsafe%'? - How-to and Troubleshooting - wpForo 2.0 https://wpforo.com/community/how-to-and-troubleshooting-2/sql-to-delete-topics-along-with-posts-where-tag-is-like-unsafe/ Discussion Board en-US Mon, 08 Jun 2026 15:15:07 +0000 wpForo 60 RE: SQL to delete Topics (along with posts), where tag is like '%unsafe%'? https://wpforo.com/community/how-to-and-troubleshooting-2/sql-to-delete-topics-along-with-posts-where-tag-is-like-unsafe/#post-46924 Sat, 17 Oct 2020 10:17:42 +0000 @mplusplus,

The replies will not be available on front-end and in dashboard. But they'll not be removed from the database.

]]> How-to and Troubleshooting - wpForo 2.0 Robert https://wpforo.com/community/how-to-and-troubleshooting-2/sql-to-delete-topics-along-with-posts-where-tag-is-like-unsafe/#post-46924 RE: SQL to delete Topics (along with posts), where tag is like '%unsafe%'? https://wpforo.com/community/how-to-and-troubleshooting-2/sql-to-delete-topics-along-with-posts-where-tag-is-like-unsafe/#post-46923 Sat, 17 Oct 2020 09:07:32 +0000 @mplusplus,

Will this delete associated replies/posts as well, please?

Yes, the replies/posts will be deleted as well.

]]> How-to and Troubleshooting - wpForo 2.0 Alvina https://wpforo.com/community/how-to-and-troubleshooting-2/sql-to-delete-topics-along-with-posts-where-tag-is-like-unsafe/#post-46923 RE: SQL to delete Topics (along with posts), where tag is like '%unsafe%'? https://wpforo.com/community/how-to-and-troubleshooting-2/sql-to-delete-topics-along-with-posts-where-tag-is-like-unsafe/#post-46913 Fri, 16 Oct 2020 19:57:40 +0000 @robert Will this delete associated replies/posts as well, please?

Thanks.

]]> How-to and Troubleshooting - wpForo 2.0 mplusplus https://wpforo.com/community/how-to-and-troubleshooting-2/sql-to-delete-topics-along-with-posts-where-tag-is-like-unsafe/#post-46913 RE: SQL to delete Topics (along with posts), where tag is like '%unsafe%'? https://wpforo.com/community/how-to-and-troubleshooting-2/sql-to-delete-topics-along-with-posts-where-tag-is-like-unsafe/#post-46903 Fri, 16 Oct 2020 12:51:42 +0000 Hi @mplusplus,

Yes, it's possible. Here is the SQL. Just replace wp_ table prefix if it's different for your WordPress database.

DELETE FROM `wp_wpforo_topics` WHERE `tags` LIKE '%unsafe%'

After executing this SQL, go to Dashboard > Forums > Dashboard admin page and click these buttons:

  1. Delete All Caches
  2. Update Forum Statistic
  3. Update Topic Statistic
  4. Update User Statistic
  5. Delete All Caches (again)
]]> How-to and Troubleshooting - wpForo 2.0 Robert https://wpforo.com/community/how-to-and-troubleshooting-2/sql-to-delete-topics-along-with-posts-where-tag-is-like-unsafe/#post-46903 SQL to delete Topics (along with posts), where tag is like '%unsafe%'? https://wpforo.com/community/how-to-and-troubleshooting-2/sql-to-delete-topics-along-with-posts-where-tag-is-like-unsafe/#post-46829 Tue, 13 Oct 2020 20:57:03 +0000 Hi there

Will it be possible for you to provide SQL to delete Topics (along with posts), where TAG is like '%unsafe%', please?

Thanks.

]]> How-to and Troubleshooting - wpForo 2.0 mplusplus https://wpforo.com/community/how-to-and-troubleshooting-2/sql-to-delete-topics-along-with-posts-where-tag-is-like-unsafe/#post-46829