how change url permalink in wordpress database by sql query

Question

I transfer WordPress website from localhost to live but there some url and images url not changes, how can change URL permalink in WordPress database by sql query or any other method.

I use below sql query but anythings not happen please help me...

UPDATE Wp_options SET option_value = replace(option_value, 'http://www.old-domain.com', 'http://www.new-domain.com') WHERE option_name = 'home' OR option_name = 'siteurl';

Thanks in advance

did my answer help you? do you need some more help?

winner_joiner
– winner_joiner

2015-12-11 12:45:27 +00:00
Commented Dec 11, 2015 at 12:45 — winner_joiner
– winner_joiner, Commented Dec 11, 2015 at 12:45

winner_joiner · Accepted Answer · 2023-01-09 09:22:55Z

20

Here is a link to an article from the official wordpress.org page, it covers most of the url changing topic.
It shows the several diverent ways how to do it and also the sql way via phpmyadmin. The raw sql is not shown, but there are several methodes.

In this Blog post a very simple way is described.

I copied the relevant sql statments from the blog post:

UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldurl', 'http://www.newurl') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://www.oldurl','http://www.newurl');

UPDATE wp_posts SET post_content = replace(post_content, 'http://www.oldurl', 'http://www.newurl');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.oldurl','http://www.newurl');

This should change the Url's easy

edited Jan 9, 2023 at 9:22

answered Dec 8, 2015 at 6:42

winner_joiner

15.3k4 gold badges42 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jeromy Adofo Over a year ago

The URLs may also be "https://" as opposed to "http://"

winner_joiner Over a year ago

of course it depends on your target domain and if you have SSL enabled or not. But for the OP it was moving from http-domain to new http-domain. In any case thanks for the added Information.

Collectives™ on Stack Overflow

how change url permalink in wordpress database by sql query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related