Delete All Pingback and Trackback Comments from WordPress Posts
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.