Title: SQL query to get set posts to published
Last modified: August 20, 2016

---

# SQL query to get set posts to published

 *  [sixfootjames](https://wordpress.org/support/users/sixfootjames/)
 * (@sixfootjames)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/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)

 *  [heaven00](https://wordpress.org/support/users/heaven00/)
 * (@heaven00)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/sql-query-to-get-set-posts-to-published/#post-3002479)
 * use xmlrpc or metaweblog
 *  Thread Starter [sixfootjames](https://wordpress.org/support/users/sixfootjames/)
 * (@sixfootjames)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/sql-query-to-get-set-posts-to-published/#post-3002613)
 * 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](https://wordpress.org/support/users/sixfootjames/)
 * (@sixfootjames)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/sql-query-to-get-set-posts-to-published/#post-3002614)
 * 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](https://wordpress.org/support/users/sixfootjames/)
 * (@sixfootjames)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/sql-query-to-get-set-posts-to-published/#post-3002661)
 * 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.

## Tags

 * [posts](https://wordpress.org/support/topic-tag/posts/)
 * [published](https://wordpress.org/support/topic-tag/published/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 2 participants
 * Last reply from: [sixfootjames](https://wordpress.org/support/users/sixfootjames/)
 * Last activity: [13 years, 9 months ago](https://wordpress.org/support/topic/sql-query-to-get-set-posts-to-published/#post-3002661)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics