Select URL From an array in WordPress MYSQL Database?

  • Unknown's avatar

    Hi!
    I’m currently moving from one theme to another on WordPress. But I have a big problem.
    My old theme has a “video” field, that’s store’s on table wp_postmeta like this:

    (213310, 21023, 'td_post_video', 'a:1:{s:8:"td_video";s:27:"https://vimeo.com/343040688";}'),

    I think is an array, but I don’t know how to extract only the Vimeo URL and Post ID for later import into my new theme ( I made a custom field for import them and show on posts, like the old theme…)

    I try with WP All Export-Import, but this plugin take all the field. :(

    I have 1400 video post, it’s crazy do this one by one.

    The blog I need help with is: (visible only to logged in users)

  • Hi there,

    Looks like you’re in the wrong forum. It appears that you’re using the open-source WordPress.org software and you need to seek help at these forums:

    https://wordpress.org/support/forums/

    These forums are for WordPress.com hosted sites only. If you want to know more about the differences between WordPress.com and WordPress.org you can read this document:

    WordPress.com vs. WordPress.org

  • The topic ‘Select URL From an array in WordPress MYSQL Database?’ is closed to new replies.