change author for multiple articles at once

Need help with the Administration of your Joomla! 3.x site? This is the spot for you.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Joomla! Apprentice
Joomla! Apprentice
Posts: 18
Joined: Sun Sep 11, 2011 5:40 am

change author for multiple articles at once

Post by lanceschuler » Mon Mar 07, 2016 8:37 am

I have around 100 articles with several authors attributed to them. I would like to batch change all the articles to one author. Any way to do that on the back end or in phpadmin?


User avatar
Joomla! Ace
Joomla! Ace
Posts: 1325
Joined: Fri Jan 22, 2016 7:10 pm
Location: Vienna - Austria

Re: change author for multiple articles at once

Post by sudo-web » Mon Mar 07, 2016 9:26 am

In PhpMyAdmin this is only one SQL line:

Code: Select all

UPDATE #__content SET created_by = <ID> ;
You have to replace #__ with your table prefix.
And the <ID> to the ID of the user you want to be the Author.

This will change all article to the new author.
If you want a constrained you have to add a where clause.
Visit me on my Webdesign Webpage:


Return to “Administration Joomla! 3.x”