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 ...

Leave a Reply

Your email address will not be published.

one × 5 =

    skype

    Need Coding Help?

    Connect Skype

    ACF

    JavaScript

    jQuery

    Others

    PHP

    WooCommerce

    WordPress

    WordPress category or taxonomy list

    WordPress custom taxonomy term list with function ...

    Conditional statement to show pagination

    Conditional statement to show pagination on WordPr ...

    WordPress Related Post

    Show related post on blog single page or any custo ...

    Most View or Popular Post on WordPress

    WordPress Post query by user views without plugin ...

    Add Custom element item in wp nav menu

    Add Element on last item of wp nav menu ...

    top