How do I change the user via SQL?

You probably haven’t changed the display name, which is probably what is being displayed. “nicename” is used for the author’s posts page url and not for display.

UPDATE wp_users SET display_name = replace(display_name, @old_user, @new_user);

Related Posts:

  1. Automatically delete inactive users after 2 months
  2. Search multiple meta keys at once
  3. Add user data to table when user is created?
  4. WordPress SQL Issue not returning correct reselts
  5. MySQL query to list users who never signed in
  6. user_login vs. user_nicename
  7. Change the Author Slug from Username to Nickname
  8. Difference between update_user_meta and update_user_option
  9. get_user_meta() doesn’t include user email?
  10. Delete all subscribers from wp_users and wp_usermeta a few thousand at a time
  11. Change the author slug from nickname to ID
  12. How to let contributors to create a new revision(draft) editing their published posts
  13. How to display custom user meta from registration in backend?
  14. Allowing an email as the username?
  15. Grouping users under parent user
  16. Display edit link if post author is current user
  17. Force display name as full name
  18. How to create a template for a custom URI associated with the user
  19. How to order users alphabetically by their last name?
  20. ‘username_exists’ still returns an ID even after deleting record from the database?
  21. Extending WP_User class and using this sub-class during the whole lifecycle
  22. Wp_User_Query not sorting by meta key
  23. How can I add a user through SQL?
  24. How we can get the user id by its display_name
  25. WP_User_Query with combined meta query – not working?
  26. How to use hyperdb to separate and share a user dataset between wordpress installs?
  27. LEFT JOIN, INNER OUTER JOIN, LEFT OUTER JOIN is driving me crazy. Please help?
  28. \WP_User Object | What’s the Difference Between {caps} and {allcaps}?
  29. Show Biographical Info while creating new user
  30. importing users where password is provided as md5 + much metadata
  31. include user profiles in search results?
  32. How to add follow functionality to multi-author wordpress site?
  33. Return ID of authors who have at least one post
  34. Where to Store Custom User Fields
  35. Plugin that would allow WordPress Authors to “follow” other Authors and query “Activity Info” from that
  36. Querying Email Addresses for a List of Users with Same Last Name?
  37. User profile custom field
  38. Authors Page : A page of authors
  39. Front end user meta options for users
  40. ACF Upload Image in front-end with custom form
  41. wp_insert_user is not working for me?
  42. Completely hide user info
  43. Hide a user from WordPress
  44. Drop down list in user profile page
  45. Check for user meta data at Login
  46. Searchable meta value in user.php
  47. How to add country drop down menu to the user profile?
  48. Total Word Count For Posts And Comments By One Author
  49. Delete user from frontend
  50. Users roles, make a page belonging to multiple users
  51. Add custom fields to the user profile
  52. Memory usage for scalable usermeta queries
  53. Select Multiple meta_value from WP DB; Single Query
  54. Is there any function available to echo current user’s profile url?
  55. stop login if user_status equal zero
  56. Does wp_delete_user() remove all user content?
  57. WP User Query fails when searching meta queries and search columns
  58. Log all users out of all locations after 24 hours
  59. How can i create an array user meta?
  60. the_author_meta(‘user_url’, $author->ID) not working properly. how can I solve this?
  61. How to set show admin bar front to true for all users?
  62. User Last Login Sort Column
  63. Updating user meta
  64. WordPress User Meta & ChromePHP or other way to debug/view php variables
  65. Use wp_update_user to update custom column in wp_users table
  66. Are User Levels Still Currently Used?
  67. WPML Default Language User Meta [closed]
  68. Where is the information about the authors for articles stored?
  69. Display users in order by an “order” custom meta field
  70. Search Users base on meta_value & meta_key
  71. mysql query two database tables, users and usermeta and sort by custom meta int value
  72. Getting author page slug from get_users() or get_userdata() functions
  73. Rest API code to get ID of current user not working: get_current_user_id() gives 0
  74. Bulk create clean user_nicename from user_email with SQL function
  75. Updating wp_user_level on user update
  76. C# user_nicename and Display name blank
  77. Should I encrypt the response that triggers an Ajax action? Is nonce sufficient?
  78. User Meta Data in a Sortable Table
  79. get_user_meta an ID for multiple functions
  80. Delete User via Frontend
  81. How to force authors to ‘submit for review’?
  82. How do I transfer user passwords from one WordPress site to another?
  83. How can I attach a user to another user with user meta
  84. Column Sorting Code on users.php
  85. Creating user without username and password
  86. I am getting mysql_real_escape_string() function error while adding user?
  87. Create Next and Previous Link to User orderby Last Name
  88. List users by meta_key and meta_value
  89. Is this code true or not
  90. MySQL query to mass change role of users
  91. users and usermeta table
  92. How to implement friend system for WordPress?
  93. User description only displayed for logged user
  94. The Simple and Correct Way to Add User Meta
  95. How to pull all the contributer users records and order by Designation (which is users meta data)?
  96. cannot get user_registered date from get_user_meta
  97. create new users in db starting at what ID?
  98. Delete Users without a First and Last Name
  99. Creating User Profiles using author.php
  100. “the_author_meta(‘url’)” not working inside “href”
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)