Month: October 2008

Change the Author of Multiple WordPress Posts

Change the Author of Multiple WordPress Posts

Disclaimer: This idea requires access to the shell on your webserver.

This is the SQL query you’ll use:

I had posts that were assigned to Admin (which by default is user ID 1), and I wanted to assign them all to my user (which in this case is user ID 2).

My query looked like this:

That will go through the posts database and update the author for all of them.


Back Again

Back Again

Sometimes I wonder how the content for this blog still exists…ย  I started this blog more than 3 years ago using Drupal, and since then I’ve converted the SQL to be used with wordpress, and had numerous problems that could have caused me to lose everything.ย  Somehow I still have it, and I’m happy that I do.

I have to say that this version of wordpress is so much better than the version I was using before (which was 2.1)

Anyways, look back for some new posts coming.

Copyright ยฉ 2024