?
Solved

replace author name in blog posts

Posted on 2013-02-05
2
Medium Priority
?
489 Views
Last Modified: 2013-02-05
I am running a wordpress site. What is the sql statement to replace all of my post authors with another user name?
0
Comment
Question by:COwebmaster
2 Comments
 
LVL 70

Accepted Solution

by:
Jason C. Levine earned 2000 total points
ID: 38857089
You don't need to do this via SQL.  Go the to Posts screen, select all posts and do Edit from the Bulk Actions pull down.  You can reassign the author on the resulting interface.
0
 

Author Closing Comment

by:COwebmaster
ID: 38857203
Thanks!
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
Suggested Courses

594 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question