How to copy user_nicename value into user_login

Run the following SQL query in PHPMyAdmin or similar.

UPDATE wp_users SET user_login = user_nicename;

wp_users is the table for users (make sure it matches yours)

Related Posts:

  1. Getting users who registered 360 days from current date
  2. Querying Email Addresses for a List of Users with Same Last Name?
  3. How to delete users with no order history through phpmyadmin sql?
  4. How change user type from contributor to author
  5. WordPress SQL Issue not returning correct reselts
  6. How can I prevent certain custom roles from seeing other custom roles on the user list page?
  7. SQL Bulk update all WordPress user’s nicknames to firstname + lastname format
  8. SELECT from wp_users, get Displayname too
  9. how to delete in phpmyadmin sql – all users with certain condition and all dependencies
  10. How to get image path from id using SQL
  11. SQL to set Display Name to First Name + Last Name
  12. Safely changing UserID’s, re-using deleted UserID’s and automatically using deleted userID’s instead of an increment
  13. Insert query not working for non-logged in user
  14. How to order posts by the user_login that corresponds to a meta_value (which is a user id)?
  15. If the current user is an administrator or editor
  16. Editor can create any new user except administrator
  17. How do I add a field on the Users profile? For example, country, age etc
  18. How do I display logged-in username IF logged-in?
  19. How to allow an user role to create a new user under a role which lower than his level only?
  20. user_login vs. user_nicename
  21. How to programatically change username (user_login)?
  22. Change the Author Slug from Username to Nickname
  23. Remove Ability for Other Users to View Administrator in User List?
  24. Difference between update_user_meta and update_user_option
  25. Make display name unique
  26. Make WooCommerce pages accessible for logged in users only
  27. Find out if logged in user is not subscriber
  28. WordPress usermeta scaling for thousands of users
  29. How to get WordPress Username in Array format
  30. Display user registration date
  31. Get multiple roles with get_users
  32. get_user_meta() doesn’t include user email?
  33. Confirmation required on email change
  34. How to Merge Two Authors Into One?
  35. Whats the best way to share user data across multiple WordPress websites?
  36. get_current_user_id() returns 0?
  37. How to get userid at wp_logout action hook?
  38. Groups of capabilities: users with multiple roles?
  39. Is there a way to merge two users?
  40. User-edit role setting distinct from wp_capabilities? [closed]
  41. List users by last name in WP_User_Query
  42. What’s the difference between the capability remove_users and delete_users?
  43. How to restrict access to uploaded files?
  44. Automatically delete inactive users after 2 months
  45. How to change user_login with wp-cli?
  46. Delete all subscribers from wp_users and wp_usermeta a few thousand at a time
  47. Email user when password is reset by admin
  48. Replacing the WordPress password validation
  49. Ban a user and end their session
  50. Allowing users to edit only their page and nobody else’s
  51. How can 2 blogs share the same users
  52. alphabetically order role drop-down selection in dashboard
  53. WordPress auto login after registration not working
  54. Change the author slug from nickname to ID
  55. Execute a function when admin changes the user role
  56. How to let contributors to create a new revision(draft) editing their published posts
  57. how to use joomla password format in wordpress?
  58. How to do get_users() with multiple meta_keys
  59. Disallowing Users of a Custom Role from Deleting or Adding Administrators?
  60. What the user_status column?
  61. How to limit users to one comment per post
  62. Different back-end language for different users?
  63. Hide Admin Menu for Specific User ID who has administrator Role
  64. Migrating WordPress users into Disqus
  65. Problem with Hebrew characters in username
  66. Is there an upper limit for users in WP?
  67. How to display the status of users (online – offline) in archive.php
  68. Remove email verification when new user register
  69. How to change user`s avatar?
  70. How to set up User email verification after Signup?
  71. Allow up to 5 Concurrent Login Sessions
  72. How to let user set password on registration
  73. How to hide media uploads by other users in the Media menu?
  74. Show admin bar only for some USERS roles
  75. How to display custom user meta from registration in backend?
  76. Allowing an email as the username?
  77. How to work around “that email address has already been used” error?
  78. Get the name of user who updated post
  79. Disable delete user
  80. Grouping users under parent user
  81. How to get the Gravityform entry ID from current user’s form submission? [closed]
  82. Retrieve all users from wordpress database via REST/JSON API
  83. Is there a way to set a user profile to Draft?
  84. Display edit link if post author is current user
  85. Check if specific username is logged in
  86. Best way to send users password?
  87. Limiting the number of users
  88. How can I get users email (and additional data) from the rest API?
  89. Force display name as full name
  90. Get users with atleast one post
  91. edit profile validation refreshes all field if missing wordpress
  92. How to update user role without logout
  93. How to hide “Filter user list” from “All Users” screen
  94. How to create a template for a custom URI associated with the user
  95. How to order users alphabetically by their last name?
  96. How to check user role without using current_user_can()
  97. How can I run a WP-CLI command as authenticated user?
  98. Why are user address fields required [closed]
  99. How to create a public profile for authors/contributors/users?
  100. Post list based on the user that is logged in