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

    Thread Starter Sam

    (@sdominique)

    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 ‘mass search and replace’ is closed to new replies.