function update_tables() {
	global $wpdb;
	for ($x=0;$x<=216;$x++): //limit for to the last blog_id created
		$table='wp_'.$x.'_options';
		$existe= $wpdb->get_results('SELECT * FROM '.$table.'');

		if ($existe)
			foreach($existe as $entry):
				if ($entry->option_name=='siteurl') {
					$siteurl=str_replace('my.old.url','my.new.url',$entry->option_value);
					$wpdb->update( $table, array('option_value'=>$siteurl), array('option_id' => $entry->option_id) );
				}
				if ($entry->option_name=='home') {
					$home=$entry->option_value;
					$home=str_replace('my.old.url','my.new.url',$entry->option_value);
				
					$wpdb->update( $table, array('option_value'=>$home), array('option_id' => $entry->option_id) );
				}
			
			
			endforeach;
	endfor;
}

add_action('init','update_tables');

http://www.hugosolar.net

Replace fields siteurl and home in wp_options tables in a wordpress multisite

wordpress, update

PHP