title: Wordpress SQL Command to Set all posts by author John Doe to draft
body: <p>I'm importing posts from another site. I've set all the posts to a specific author (John Doe in this case) and I now want to run an SQL query (in PHPMyAdmin) that gets all John's posts and sets them to draft. Ideas?</p>