WordPress.org

1. subirghosh
   Member
   Posted 5 years ago #

   For reasons of consistency in the word count, I want to delete all the (optional) excerpts that had been entered on a site I am working on currently.

   So in the table called posts, I want to empty the row called post_excerpt. How should I do that?

   I don't want to delete the row, I just want to empty it.

   I don't know phpmyadmin so well so as to be adventurous with this.

   TIA.

   Subir

2. subirghosh
   Member
   Posted 5 years ago #

   I am trying:

   SELECT * FROM wp_posts TRUNCATE post_excerpt

   It does not work.

3. mrbrown
   Member
   Posted 5 years ago #

   try:

   UPDATE wp_posts SET post_excerpt = '';

   this will empty all post_excerpt fields in the wp_posts table.

4. subirghosh
   Member
   Posted 5 years ago #

   Thank you very much, Mr Brown. Needless to say, it worked :)

Topic Closed

This topic has been closed to new replies.