WordPress.org

Ready to get started?Download WordPress

Forums

SQL query to get set posts to published (5 posts)

  1. sixfootjames
    Member
    Posted 1 year ago #

    Hi,

    Anyone know of an SQL query I can run to quickly change the 1500 odd posts I imported to PUBLISHED?

    Many thanks :)

  2. heaven00
    Member
    Posted 1 year ago #

    use xmlrpc or metaweblog

  3. sixfootjames
    Member
    Posted 1 year ago #

    Thanks Heaven, I have never used XML Rpc abd am reading about it now but how does this allow me to change a multitude of posts at once?

  4. sixfootjames
    Member
    Posted 1 year ago #

    Right, so I've had a read and it seems like the best route to go would be through something like Zoundry Raven, a desktop blogging tool after I have enabled XML Rpc in WordPress?

  5. sixfootjames
    Member
    Posted 1 year ago #

    Nope, that didn't do the trick either. And I have done a fair amount of reading on this today which means I need to learn this API. Which I don't mind doing and will learn, but for now I need a simpler solution to my problems please, as there are more of these SQL queries that I will need to run for other elements of the posts that I have uploaded.

    Many thanks!

Topic Closed

This topic has been closed to new replies.

About this Topic