MySQL like Delete all comments with a specific url: DELETE from wp_comments WHERE comment_author_url LIKE "%wordpress.org%";