When I was cleaning my website from spams, I noticed a high number of comments (600+) in admin dashboard. Instead of going through one by one and deleting them, I decided to nuke all unapproved comments with this sql query:

```
delete from wp_comments where comment_approved = 0

```

Now my admin dashboard is STILL showing the same number of comments but all the actual comments are gone. How do I reset this counter back to zero.
[![Comment Counter still not reset](https://i.stack.imgur.com/1ovi2.png)](https://i.stack.imgur.com/1ovi2.png)