Wordpress change url phpmyadmin

UPDATE wp_options SET option_value = replace(option_value, 'oldurl.com', 'newurl.com') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = replace(guid, 'oldurl.com','newurl.com');
UPDATE wp_posts SET post_content = replace(post_content, 'oldurl.com', 'newurl.com');
UPDATE wp_postmeta SET meta_value = replace(meta_value,'oldurl.com','newurl.com');

Source: hostinger.com

Similar codes

3 votes167 views1 answer
Sql server version query
SQL
1 vote171 views1 answer
Md5 encryption for existing records
SQL
1 vote185 views1 answer
Declare table variable
SQL
0 vote174 views1 answer
What is default mysql database password in linux
SQL
0 vote169 views1 answer
Date diff sql
SQL
3 votes182 views1 answer
Sql insert inserted id
SQL
0 vote161 views1 answer
View acl table oracle
SQL
0 vote162 views1 answer
Wordpress sql change site url
SQL
1 vote176 views1 answer
Join first name and last name sql
SQL
0 vote178 views1 answer
Name '_mysql' is not defined
SQL