![]() Unapproved comments have not been published on your site yet. Repeat the same steps for the following query to remove all comments that are unapproved - replacing wp_comments with the name of your comments table.Paste in the following query to remove all comments marked as spam, replacing wp_comments with the name of your comments table.ĭELETE FROM wp_comments WHERE comment_approved = 'spam'.Click SQL in the menu at the top of the screen.Method 2: Run a query to remove spam and unapproved comments Scroll all the way down and click Empty the table (TRUNCATE).Click Operations in the menu at the top of the screen.Make sure you have opened the table that you want to empty.We will show both methods, you should pick one. Alternatively, you can run queries to remove spam and unapproved comments in batches. This means that all comments will be deleted, also the legitimate ones. ![]() The easiest way to delete spam comments is to empty the entire table. This is where all your WordPress comments are stored. It has the prefix followed by _comments like wp_comments, blog_comments, etc. In the menu to the left, click on the comments table. Step 2 - Open your database in phpMyAdminĬlick the drop-down menu for phpMyAdmin in the top-right corner, and select the database from where you want to remove spam comments.
0 Comments
Leave a Reply. |