Change link from old domain to new domain link in Wordpress

gistfile1.php

<?php
	# Change link from old domain to new domain in Wordpress
 	require_once('wp-config.php');
	global $wpdb;

        $newDomain = "newdomain.com";
        $oldDomain = "olddomain.com";

        # Posts
        $query = "SELECT ID, post_content FROM wp_posts WHERE post_content LIKE '%" . $oldDomain . "%';";

        $results = $wpdb->get_results($query);
        foreach($results as $result) {
                $text = str_replace($oldDomain, $newDomain, $result->post_content);
                $wpdb->query(
			$wpdb->prepare("UPDATE wp_posts SET post_content = %s WHERE ID = %d", $text, $result->ID)
		);
        }

        # Options
        $query = "SELECT option_id, option_value FROM wp_options WHERE option_value LIKE '%" . $oldDomain . "%';";
        
        $results = $wpdb->get_results($query);
        foreach($results as $result) {
                $text = str_replace($oldDomain, $newDomain, $result->option_value);
                $wpdb->query(
                        $wpdb->prepare("UPDATE wp_options SET option_value = %s WHERE option_id = %d", $text, $result->option_id)
                );
        }