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 user_nicename = replace(user_nicename, @old_user, @new_user); UPDATE wp_usermeta SET meta_value = replace(meta_value, @old_user, @new_user);
However, while posting a new one, the author is still the old one, for instace,
Posted on October 3, 2015 by old_user.
I must ignore something, please guide me.