SQL query to get set posts to published

  • Hi,

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

    Many thanks ??

Viewing 4 replies - 1 through 4 (of 4 total)

  • use xmlrpc or metaweblog

    Thread Starter sixfootjames

    (@sixfootjames)

    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?

    Thread Starter sixfootjames

    (@sixfootjames)

    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?

    Thread Starter sixfootjames

    (@sixfootjames)

    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!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘SQL query to get set posts to published’ is closed to new replies.