/SQL/Wordpress change http to https phpmyadmin

Wordpress change http to https 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

0 vote170 views1 answer
Search from comma separated values in sql server
SQL
0 vote156 views1 answer
Oracle sql count occurrences of value in column
SQL
10 votes165 views4 answers
How to alter table name in mysql
SQL
15 votes208 views5 answers
Show tables in oracle
SQL
0 vote163 views1 answer
Possgress drop if exists view
SQL
0 vote183 views1 answer
Least spark sql
SQL
0 vote200 views1 answer
Postgresql import data from csv
SQL
0 vote166 views2 answers
T sql null or empty string
SQL
2 votes181 views3 answers
Mysql list tables by size
SQL
12 votes217 views10 answers
Google
SQL