SQL Query for mass edit custom field

  • exilod

    (@exilod)


    11 years, 8 months ago

    Hello everybody!
    I have a question.
    I am running detube theme which has a custom field named “dp_video_code” in which i put my video embeded code. Recently the embeded code has change and I need to modify the video code in all posts(I need to replace the text “preview” from the code with “edit”). Is there anyway to do this without take all posts one by one?
    Can I be done with a sql query? If yes what would that be?

    Thanks!

Viewing 1 replies (of 1 total)
  • vtxyzzy

    (@vtxyzzy)

    11 years, 8 months ago

    BEWARE – this is dangerous. Make sure you have a valid backup first!

    $meta_key = 'dp_video_code';
$search_for = 'preview';
$replace_with = 'edit';
$sql = "UPDATE $wpdb->postmeta
SET meta_value = REPLACE(meta_value, '$search_for', '$replace_with')
WHERE meta_key = '$meta_key'
";
$results = $wpdb->get_results($sql);
Viewing 1 replies (of 1 total)

The topic ‘SQL Query for mass edit custom field’ is closed to new replies.