/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 vote343 views1 answer
Sql contains vs like
SQL
0 vote331 views1 answer
Provera dupliranih konatakata
SQL
0 vote366 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
0 vote383 views1 answer
Cube oracle
SQL
0 vote333 views1 answer
TSQL function split string
SQL
2 votes334 views1 answer
How to add where command in update comand with joins
SQL
0 vote347 views1 answer
How to put value in parameters in mysqldataadapter
SQL
7 votes357 views3 answers
Select latest entry in sql table
SQL
0 vote333 views1 answer
Oracle create table auto generated primary key
SQL
21 votes341 views3 answers
Sql average
SQL