admin管理员组

文章数量:1420575

My wordPress database was hacked and all users_names were changed to the same thing. I'd like to write a mySql query to replace all usernames that = "x" to the user_nicename. I'm unsure how to do this - any suggestions?

My wordPress database was hacked and all users_names were changed to the same thing. I'd like to write a mySql query to replace all usernames that = "x" to the user_nicename. I'm unsure how to do this - any suggestions?

  • query
  • mysql
Share Improve this question asked Nov 4, 2015 at 19:14 ckgckg 111 bronze badge
Add a comment  | 

2 Answers 2

Reset to default 2

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"

To update the Nickname use: 

UPDATE wp_users SET user_nicename = 'new_nick_name' WHERE user_nicename = 'x';

本文标签： queryMy SQL function to change username

版权声明：本文标题：query - My SQL function to change user_name 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1745335005a2653996.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。