0

I am using MySQL Workbench to search for URL's in my DB, in order to use sql's update() to change them to a different URL. Easy enough. What bugs me is even then, some of these URL's, nearly all of which were typed into post content sections by users, do not show up in the obvious places, like wp_posts, or even when I search the entire schema.

Any tips on where else post_content is stored, aside from post_content

Improve this question
1
  • 1
    If you use any pagebuilders or custom fields, they may be stored in meta_value in wp_postmeta. Have you tried searching for just a portion of the URL? Maybe some of the characters got escaped or encoded oddly?
    – WebElaine
    Commented Sep 25, 2017 at 20:37

1 Answer 1

Reset to default
1

WordPress store the content from the editor inside the table post_content. But if you use additional plugins for your editor it is possible to store on different places, like custom tables and also in post_meta, really popular for third plugins to store date there use the meta API.

Small hint, maybe you should use a a plugin for search/replace in the database if you not so familiar with the search about all tables. Makes easier to find the right point there store your data.

Improve this answer

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.