Title: WordPress SQL Queries
Last modified: August 20, 2016

---

# WordPress SQL Queries

 *  [diragusa](https://wordpress.org/support/users/diragusa/)
 * (@diragusa)
 * [14 years, 1 month ago](https://wordpress.org/support/topic/wordpress-sql-queries/)
 * Im wanting to delete posts in my wordpress multisite via mysql database.
    I know
   the querie to use but I want to skip a few sites so that they delete any posts
   in them.
 * What do I modify or add in this code?
    `DELETE FROM wp_posts WHERE post_date 
   < '2010-01-01 19:18:00' AND post_status = 'publish'`
 * my multisite sites are split like this wp_2_posts,wp_3_posts etc etc.
 * thanks

The topic ‘WordPress SQL Queries’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [delete](https://wordpress.org/support/topic-tag/delete/)
 * [multisite](https://wordpress.org/support/topic-tag/multisite/)
 * [remove](https://wordpress.org/support/topic-tag/remove/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)
 * [SQL queries](https://wordpress.org/support/topic-tag/sql-queries/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [diragusa](https://wordpress.org/support/users/diragusa/)
 * Last activity: [14 years, 1 month ago](https://wordpress.org/support/topic/wordpress-sql-queries/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics