昨日当年

DELETE FROM wp_postmeta WHERE meta_key = '_thumbnail_id';

global $wpdb;
$wpdb->query( "
    DELETE FROM $wpdb->postmeta
    WHERE meta_key = '_thumbnail_id'
" );