Skip to content

Instantly share code, notes, and snippets.

@ramsesdelr

ramsesdelr/update_user_login.sql

Last active May 27, 2021 14:15
Show Gist options
  • Save ramsesdelr/40566f48ea58eb73177d11de945b47e2 to your computer and use it in GitHub Desktop.
Save ramsesdelr/40566f48ea58eb73177d11de945b47e2 to your computer and use it in GitHub Desktop.
Download ZIP
Update WP user_login based on user_nicename
Raw
update_user_login.sql
UPDATE wp_users inner join (select user_nicename, ID FROM wpxv_users ) users_2 ON wp_users.ID = users_2.ID SET user_login = users_2.user_nicename
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment