My SQL function to change user_name

This should be working:

Be sure that your DB prefix is “wp_”

Update wp_users set wp_users.user_login=wp_users.user_nicename where wp_users.user_login="x"

Related Posts:

  1. simple sql query on wp_postmeta very slow
  2. How many WordPress SQL Queries per page?
  3. Multipart/formatted MySQL query problem
  4. Are database queries created using WordPress filters protected from SQL injection?
  5. Grouping related postmeta data via SQL query
  6. Mysql / WordPress killing my server with 80k users [closed]
  7. Slow meta_query with about 4 milion record on wp_postmeta
  8. Select User by Joining Multiple Meta Value Results
  9. mySQL query. ORDER BY meta_key
  10. Update slug (URL) of pending posts via phpMyAdmin
  11. You have an error in your SQL syntax – Help with query
  12. MySQL variable in query
  13. how would I create a custom query to get all users, and a related post based on a postmeta field?
  14. Help with MySQL to $WPDB query
  15. SQL query to select posts from multiple categories
  16. How do I see the mysql query generated by get_posts( $args )?
  17. Alter query with posts_clauses to retrieve NULL values last
  18. MySql Query very slow
  19. Searching With Apostrophe
  20. WordPress Query wp-terms SLOW
  21. wpdb COALESCE won’t work
  22. Get posts from category with custom query
  23. how to insert missing tags into the posts through mySQL?
  24. Ideas how to search & replace post_content when string contains a newline?
  25. Valid SQL query return empty
  26. mysql query – how to escape apostrophe?
  27. Query the WordPress database to get data together with replaced information
  28. Optimize slow SQL query for multiple meta values
  29. Updating with $qpdb->query() always returns 0 rows affected
  30. How to return count of custom post type posts with a specific custom field value via $wpdb?
  31. WordPress Mysql query and Duplicate
  32. Help with Related Posts Function
  33. How to delete all images from code in all post_content
  34. I want to get on those users their meta value are like “AGENT” .. but this query is not working
  35. Displaying data from custom table
  36. Get 2 meta values from meta key column
  37. PHP Fatal error: Uncaught Error: Call to a member function insert() on null
  38. SQL query to delete users with multiple meta keys and comments
  39. OR condition not working
  40. Trouble migrating custom post types from non-wordpress cms
  41. Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
  42. Performance of wp_get_attachment_image_srcset() and wp_get_attachment_image_url()
  43. How to make MySQL search queries with quotes
  44. Custom MySQL Query for Post and Post Meta
  45. Mysql query and odd results
  46. sql for querying post and their category
  47. Access Tables with number prefix
  48. Custom query_var causes displaying posts archive on front page
  49. What is the most efficient way of implementing a favorite post system?
  50. Why does get_the_time(‘F j’) return November 30 for all posts?
  51. Query by one meta_key and sort by another (possibly NULL value)
  52. Query & Sort Comments by custom comment meta
  53. is_archive() doesn’t work on public query var archive pages?
  54. How to count get_users query?
  55. Possible to get posts from multiple meta keys/values in a single query?
  56. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  57. Difference between fragment caching and wp_cache
  58. How to display all posts with today’s same month and day only?
  59. Show featured image as background image from postQuery
  60. Using $wpdb->update but confused on the WHERE in and SET
  61. WordPress Loop: List All Posts by a Category & Subcategory
  62. Order query by post meta value
  63. CRUD operations using WordPress database API
  64. Why is variable not working on custom sql query using wpdb?
  65. List all posts from past week grouped by sub-category
  66. Query Custom Post Type posts by Keyword/url slug
  67. Display posts with a start OR end date later than current date
  68. Order posts by custom field DATE value
  69. Slow queries constantly getting stuck on WordPress database of ~100,000 posts
  70. Query to Get All Users from wp_users With NO matching user_id In wp_usermeta
  71. WordPress custom setting page – add flashing message
  72. Custom query AFTER rss fetch_feed not working
  73. Multiple Category Query
  74. Passing parameters to a static front page
  75. wp_list_pages() refuses to output posts
  76. Can’t seem to do combined query AND sort?
  77. sort query results by newest
  78. How to reset usual $query on search page to push custom $wpdb query there?
  79. Best practice to limit results in get_row()?
  80. $wpdb->prepare affecting the query?
  81. WordPress SQL search, how to handle SQL Injection?
  82. How to manage a particular “order by” for get_search_query()?
  83. Query to view scheduled or draft post
  84. How to add a Variable to post query
  85. Sort a list of a CPT ( job) if a meta is empty
  86. Restore WordPress Backup Locally?
  87. How to do a MySql query in WordPress?
  88. “order” does not affect order of custom query
  89. Create a new post on a specified publish date via link?
  90. Query String for the WP_QUERY parameters
  91. $wpdb query for price in custom field value
  92. Multiple terms not working on taxonomy
  93. Sorting of coupons in the right way
  94. excludeCat function reverses order of blog posts
  95. Run search query again without pagination gives no results?
  96. Parsing External Table Arguments
  97. WP_Query orderby meta key/value suddely stopped working
  98. Where can I find the SQL to get the most used information by wordpress database?
  99. WooCommerce Total # orders [closed]
  100. How to show sticky posts on all pages of the pagination, not just the first page?