[wp-hackers] Unpublish posts by author

Daniel Torreblanca regulatethis at gmail.com
Tue Mar 25 20:43:56 GMT 2008

I'm guessing something like

UPDATE `wp_posts` SET `post_status`='draft' WHERE
`post_author`=<INSERT ID OF AUTHOR HERE>

would do the trick :)

On Tue, Mar 25, 2008 at 4:39 PM, Chris Jernigan <chrisjernigan at gmail.com> wrote:
> Hello all,
>  I've searched everywhere (obviously unsuccessful in finding answers)
>  for a way to unpublish all posts by a particular author at one time.
>  How might I go about doing this? Anyone know of a plugin or database
>  hack or ...?
>  Thank you in advance for your help.
>  Chris Jernigan
>  _______________________________________________
>  wp-hackers mailing list
>  wp-hackers at lists.automattic.com
>  http://lists.automattic.com/mailman/listinfo/wp-hackers

"Never attribute to malice that which is adequately explained by stupidity"

More information about the wp-hackers mailing list