WordPress.org

Support

Support » Plugins and Hacks » [Resolved] mass search and replace

[Resolved] mass search and replace

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Stefan Boonstra

    @stefanboonstra

    Hi,

    The table that stores the slideshow’s slides is the ‘wp_postmeta’ table. The ‘meta_value’ column stores the slide data. This would make your query look something like this:

    UPDATE wp_postmeta SET meta_value = REPLACE (
        meta_value,
        'Item to replace here',
        'Replacement text here'
    );

    Best regards,
    Stefan

    Thanks. Is there an issue with serialized data breaking with this slideshow widget if I do a search and replace?

    Plugin Author Stefan Boonstra

    @stefanboonstra

    When looking at the serialized data in PHPMyAdmin, it looks like it won’t be that much of a problem. If the replace query doesn’t match any records, you won’t have any results anyway. You can use an online PHP serializer to check if there will be any complications with your data.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘[Resolved] mass search and replace’ is closed to new replies.