I forgot about it so, so frequently that I decided to jot down the syntax.
For example, to make all the posts unpublished in Ghost:
update posts set status = "draft";
Or if you want to add the condition:
update posts set status = "draft" where author_id = "1";