Skip to content

Instantly share code, notes, and snippets.

@rachellawson
Created October 16, 2013 12:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rachellawson/7006752 to your computer and use it in GitHub Desktop.
Save rachellawson/7006752 to your computer and use it in GitHub Desktop.
find user accounts created by bots that have same first and last names and then disable
update users
join field_data_field_first_name first ON entity_id = uid
join field_data_field_last_name last on last.entity_id = uid
SET status = 0 where first.field_first_name_value = last.field_last_name_value;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment