How to Delete All Spam Comments at Once in WordPress Database with phpMyAdmin

Описание: In this wordpress tutorial for beginners you will learn how to remove all spam comment at same time from wordpress database using my sql query in phpmyadmin. So you can removed all spam comments by using sql query. So you can optimize your database table by removing unused data using this step.

** in query add your database prefix.

-------------------------

1- Delete Spam Comments
Run SQL Query: To delete all spam comments, run the following query:

DELETE FROM wp_comments WHERE comment_approved = 'spam';

---------------------

Replace wp_ with your table prefix if it’s different.

#database #spam #comment #comments #optimize #table #data #query #sql #mysql #phpmyadmin #website #wordpress #wordpresstutorial #webtaskwithhassan #hassangilani