If you have both lists in MySQL, another option would be: DELETE mailing_list.* FROM mailing_list, unsub_list WHERE mailing_list.email = unsub_list.email;