All Questions
2 questions
0
votes
3
answers
589
views
How do I change the user via SQL?
I change a user via SQL in wordpress:
SET @old_user='old_user';
SET @new_user='new_user';
UPDATE wp_users SET user_login = replace(user_login, @old_user, @new_user);
UPDATE wp_users SET ...
- 233
0
votes
2
answers
1k
views
Getting list of top 10 users and sort on last name
I would like to display a list of the top 10 authors based on the amount of posts that they have, and then sort them on last name. To my knowledge, this is not trivial since the last name of a user ...
- 395