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.
- The topic ‘WordPress SQL Queries’ is closed to new replies.