Title: Edit WordPress posts with phpmyadmin
Last modified: May 16, 2022

---

# Edit WordPress posts with phpmyadmin

 *  Resolved [JCM](https://wordpress.org/support/users/chrisjeret/)
 * (@chrisjeret)
 * [4 years ago](https://wordpress.org/support/topic/edit-wordpress-posts-with-phpmyadmin/)
 * Hi I’m not sure if this is the right place to ask but could someone provide a
   solution for me?
 * I’m trying to edit WordPress posts using phpmyadmin. The reason I’m doing this
   is I’m having issues with one of the plugins and it’s complicated to even explain.
 * I have found the the db and posts and edited directly with phpmyadmin and I also
   tried sql command to update the posts. It’s basically just updating certain text
   in the posts. Running or updating in phpmyadmin was successful but it is not 
   reflecting in the wordpress site.
 * So I’m not sure if there is anything else that needs to be done?
    -  This topic was modified 4 years ago by [JCM](https://wordpress.org/support/users/chrisjeret/).

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

 *  [Dion](https://wordpress.org/support/users/diondesigns/)
 * (@diondesigns)
 * [4 years ago](https://wordpress.org/support/topic/edit-wordpress-posts-with-phpmyadmin/#post-15647723)
 * If you’re using a cache plugin, you’ll need to purge the cache in order to see
   the changes. Purging may also be necessary if you’re using a proxy cache such
   as CloudFlare, or a server-level cache such as Redis, Memcached, or Varnish.
 *  Thread Starter [JCM](https://wordpress.org/support/users/chrisjeret/)
 * (@chrisjeret)
 * [4 years ago](https://wordpress.org/support/topic/edit-wordpress-posts-with-phpmyadmin/#post-15647750)
 * hi im working on a localhost first to test it out before i do it on the production
   site and i do not have any cache plugin installed. i also tried using some search
   and replace plugin and that did not work either.
 * on phpmyadmin i did this …
 * UPDATE `wp_posts` SET `post_content` = REPLACE(post_content, ‘Alex’, ‘Robert’)
   WHERE post_type=’page’ AND post_status=’publish’
 *  [Dion](https://wordpress.org/support/users/diondesigns/)
 * (@diondesigns)
 * [4 years ago](https://wordpress.org/support/topic/edit-wordpress-posts-with-phpmyadmin/#post-15651041)
 * When you run that query, phpMyAdmin will tell you how many rows were affected
   by the query. Please make sure the number is nonzero.
 * Also, are you sure the post you’re trying to edit is in fact a page?
 * It would be beneficial if you knew beforehand some of the post IDs whose content
   you want to change. In that way you can view them in the WP editor (Gutenberg
   or Classic) to see what is in fact occurring.
 *  Thread Starter [JCM](https://wordpress.org/support/users/chrisjeret/)
 * (@chrisjeret)
 * [4 years ago](https://wordpress.org/support/topic/edit-wordpress-posts-with-phpmyadmin/#post-15651171)
 * [@diondesigns](https://wordpress.org/support/users/diondesigns/) thanks for the
   input but I found a plugin that actually works. Tried few different plugins and
   finally found one that actually write the changes. It’s WP Migrate Lite plugin.

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

The topic ‘Edit WordPress posts with phpmyadmin’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 2 participants
 * Last reply from: [JCM](https://wordpress.org/support/users/chrisjeret/)
 * Last activity: [4 years ago](https://wordpress.org/support/topic/edit-wordpress-posts-with-phpmyadmin/#post-15651171)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics