Delete All Pingback and Trackback Comments from WordPress Posts

Print Page

A quick bit of code to delete all trackback or pingback comments from every post on a WordPress site. All other comments on posts remains intact.

DELETE FROM wp_comments WHERE wp_comments.comment_type = 'pingback';
DELETE FROM wp_comments WHERE wp_comments.comment_type = 'trackback';

Access database via phpMyAdmin and run this SQL query.