Change WordPress URL in Database with phpMyAdmin and SQL query

Replace WordPress old URL to new URL with SQL Query

First, make sure you are on correct database on phpMyAdmin.

September 22, 2022

Put the below code under the SQL tab and press go.

Before you press go make sure you change youroldsite.com and yournewsite.com

SQL Query
UPDATE wp_options SET option_value = replace(option_value, 'https://youroldsite.com', 'https://yournewsite.com') WHERE option_name = 'home' OR option_name = 'siteurl';UPDATE wp_posts SET guid = replace(guid, 'https://youroldsite.com','https://yournewsite.com');UPDATE wp_posts SET post_content = replace(post_content, 'https://youroldsite.com', 'https://yournewsite.com'); UPDATE wp_postmeta SET meta_value = replace(meta_value,'https://youroldsite.com','https://yournewsite.com');
Previous Code

Create a new WordPress administrator via functions.php & FTP

TweetShareSharePin0 Shares ...

Next Code

Allow Only Business Email Addresses in the Email Field of Elementor Forms

Accept submissions from Business emails on Element ...

Leave a Reply

Your email address will not be published. Required fields are marked *

8 + 19 =

If you find it useful

Buy me a coffee

ACF

Elementor

JavaScript

jQuery

Others

PHP

WooCommerce

WordPress

Remove Website field from WordPress comment & Change cookies remember text

Remove Website field from WordPress comment & Chan ...

WordPress .htaccess code for redirect www to non www url

Remove www from url or redirect ...

Conditional statement to show pagination

Conditional statement to show pagination on WordPr ...

wp-config development code

WordPress post revisions, debug, load-scripts.php ...

WordPress category or taxonomy list

WordPress custom taxonomy term list with function ...

top