/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 vote158 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
0 vote141 views1 answer
Oracle right characters
SQL
0 vote202 views1 answer
Sqlite display headers on columns
SQL
0 vote134 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
1 vote162 views1 answer
How do you use sql in you company
SQL
0 vote154 views1 answer
Sql server python connection
SQL
0 vote100 views1 answer
Big query add table rows to another table
SQL
0 vote168 views1 answer
Start stop mysql linux
SQL
0 vote143 views1 answer
Python connect microsoft sql server
SQL
0 vote137 views1 answer
Add column not null with default value postgres
SQL