sql

Thanks to AmbitiousAmoeba for the answer. The following improved code solves the problem: function filter_where( $where=”” ) { global $wpdb; $where .= ” AND (($wpdb->postmeta.meta_key = ‘original_date’ AND $wpdb->postmeta.meta_value >= ‘2000-01-01’) AND ($wpdb->postmeta.meta_key = ‘original_date’ AND $wpdb->postmeta.meta_value <= ‘2004-12-31’)) “; return where; } add_filter(‘posts_where’, ‘filter_where’); query_posts($query_string); while (have_posts()) : the_post(); the_content(); endwhile;

First take a db backup! Second, in your question you mention the same meta_key, so made the following assumption: The meta_key you want to keep is “ehp_citation” The meta_key you want to change is “ehp_citation_old” * so make the correction accordingly Then you can try something like: UPDATE `wp_postmeta` AS pm_to_change LEFT JOIN `wp_postmeta` AS … Read more