/WordPress how to delete all pending spam comments

WordPress how to delete all pending spam comments

Video: WordPress how to delete all pending spam comments

Subtitles

Hi guys and welcome to this WordPress tutorial this is Jamie from https://www.system22.net and http://web-design-and-tech-tips.com/ well if you're running a WordPress site and you may get a lot of spam a lot of comments that you need to delete I've got a site up here that's got to six thousand two hundred and ninety-six comments that have not been approved yet and they've got a plug-in here that is called delete pending comments I've used that before it works pretty well but it doesn't seem to be working very well for this if you want to check it out just put delete my plugins into your plugin search and it'll come up but this particular one hasn't been updated for about six years that may be possibly why it's not working on this site here at the moment I have used it in the past and it does work so you're welcome to try it but if this doesn't work for you and of course it's another plugin that you've got to have on your site there's a different option what you need to do is log into your cPanel of your hosting it may look slightly different for this but it'll have all the same features and you need to go your PHP myadmin and find the database that we need for this site which i've got here and just click on the database that pertains to your site be careful do not do this for any other database make sure you've got the correct database go up to the SQL tab and you can put in a piece of code a short line of code and it's basically telling it to delete from the WP comments anything that has been unapproved once I've put that in I'm just gonna hit go it's gonna check like actually want to do that I certainly do okay and now it's told when it's six thousand two hundred ninety seven rows have been effective so it should have done that let's go back to our site and as you can see Mirza sixty two hundred comments say let's do a refresh and those should have disappeared now there we go they're all gone so that's a quick and easy way of deleting a bunch of pending comments like I say you can try that plug-in if you wish I've got the same site here it's called delete pending comments it may work for you but if it doesn't you can use this other method like I say you need to go to your cPanel into your PHP my admin find the database that relates to that site make sure you have the correct database once in there go to the SQL tab and put in this line of code here and I'll put this below the video so you can copy it and use it if you wish so I hope you found that useful if you have please give it a thumbs up share it and subscribe to our YouTube channel if you're interested in web development have a look down below this video we've got some great free web development courses as well as some premium courses with some huge discounts for our YouTube subscribers so do take a look once again this has been jamie from system 22 and web design and tech tips comm thanks for watching have a great day.

READ  OK Google Setup for Sesame voice commands