I'm moving everything that is displayed with the_content in custom fields and i want to remove/emtpy the content of the post_content column in the database, for every post.

Is there a mysql query that does that or another way?

1 Answer 1


You can use UPDATEwp_postsSETpost_content="" WHERE 1

  • That works. I needed to do this only for the default post type so i run UPDATE wp_posts SET post_content="" WHERE post_type='post'. Thank you.
    – CK13
    Commented Dec 28, 2014 at 16:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.