Skip to content

Instantly share code, notes, and snippets.

@Fosome
Last active August 29, 2015 14:07
Show Gist options
  • Save Fosome/f83a3b47ad0af8b31708 to your computer and use it in GitHub Desktop.
Save Fosome/f83a3b47ad0af8b31708 to your computer and use it in GitHub Desktop.
DELETE `exp_members`
FROM `exp_members`, `exp_member_data`, `exp_member_homepage`
WHERE `exp_members.member_id` = `exp_member_data.member_id`
AND `exp_members.member_id` = `exp_member_homepage.member_id`
AND `exp_member_data.m_field_id_1` = `exp_member_data.m_field_id_2`
AND `exp_member_data.m_field_id_1` != ''
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment