MySQL like

Delete all comments with a specific url:

DELETE from wp_comments WHERE comment_author_url LIKE "%wordpress.org%";