Title: Need help with phpmyadmin
Last modified: August 18, 2016

---

# Need help with phpmyadmin

 *  [subirghosh](https://wordpress.org/support/users/subirghosh/)
 * (@subirghosh)
 * [19 years, 1 month ago](https://wordpress.org/support/topic/need-help-with-phpmyadmin/)
 * 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

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Thread Starter [subirghosh](https://wordpress.org/support/users/subirghosh/)
 * (@subirghosh)
 * [19 years, 1 month ago](https://wordpress.org/support/topic/need-help-with-phpmyadmin/#post-556335)
 * I am trying:
 * SELECT * FROM `wp_posts` TRUNCATE `post_excerpt`
 * It does not work.
 *  [Claudio Simeone](https://wordpress.org/support/users/mrbrown/)
 * (@mrbrown)
 * [19 years, 1 month ago](https://wordpress.org/support/topic/need-help-with-phpmyadmin/#post-556338)
 * try:
 * `UPDATE wp_posts SET post_excerpt = '';`
 * this will empty all `post_excerpt` fields in the `wp_posts` table.
 *  Thread Starter [subirghosh](https://wordpress.org/support/users/subirghosh/)
 * (@subirghosh)
 * [19 years, 1 month ago](https://wordpress.org/support/topic/need-help-with-phpmyadmin/#post-556339)
 * Thank you very much, Mr Brown. Needless to say, it worked 🙂

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Need help with phpmyadmin’ is closed to new replies.

## Tags

 * [empty](https://wordpress.org/support/topic-tag/empty/)
 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)
 * [row](https://wordpress.org/support/topic-tag/row/)
 * [tables](https://wordpress.org/support/topic-tag/tables/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 2 participants
 * Last reply from: [subirghosh](https://wordpress.org/support/users/subirghosh/)
 * Last activity: [19 years, 1 month ago](https://wordpress.org/support/topic/need-help-with-phpmyadmin/#post-556339)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics