Ramsés Del Rosario ramsesdelr
ramsesdelr
/ update_user_login.sql
Last active
May 27, 2021 14:15
Update WP user_login based on user_nicename
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |