WordPress.org

Forums

WordPress SQL Queries (1 post)

  1. diragusa
    Member
    Posted 3 years ago #

    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

Topic Closed

This topic has been closed to new replies.

About this Topic