cleaning spam posts from wordpress database

[Ahmet Tuter]

for my wordpress site i am cleaning my database from spam, which were somehow inserted there, but my site is working regardless. i opened phpmyadmin, the table wp_posts. so i simply go to the tab that says browse, go over the posts one by one, find spam posts and just hit delete and those posts are physically removed right?

but what about the table called wp_postmeta? dont all the possts in wp_posts have a corresponding entry in wp_postmeta? if so , if i delete spam posts from posts table will it be a problem or it is ok?

even if it is ok, the meta for the spam post means it is still in postmeta table if i delete just the post. so is there a better way to clean faster and both? i didnt touch anything yet. i want to know first