How to batch edit post content through mysql

  • I would appreciate if anyone could tell me how to batch edit multiple post content using only mysql, that means running a sql query. I tried editing the post content of some rows but despite the change is made, it never actually shows up in the post, meaning, if I search the post from the control panel it shows the modifications I introduced, but until I UPDATE POST pressing the button, the changes never appear in the page.

    Any suggestions? I’d also take into consideration any php script for batch post editing.

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

  • Going to guess that your post content is cached, and changing via MySQL doesn’t update the cache where updating via the admin menus does update the cache.

    Thread Starter blogginginc

    (@blogginginc)

    Thanks for your answer. I’m actually using super cache plugin. But despite I do delete manually the content from the folder supercache, it still doesn’t reflect the changes, maybe there’s some more cache to be deleted in another folder (like meta or cache folder).

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘How to batch edit post content through mysql’ is closed to new replies.