Query to set all users blog posts as not visible (vb4)

[tpearl5]

This query will set all of one user's blog posts to not visible (not a hard delete):

UPDATE `blog` SET `state` = "deleted" WHERE `username` = "USERNAME" AND `state` = "visible";

You can reverse this by swapping 'deleted' and 'visible' for state =