/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 vote317 views1 answer
Selects all the columns from the sailors table
SQL
0 vote330 views2 answers
Oracle create chain rule
SQL
0 vote322 views1 answer
Psql no such file or directory
SQL
1 vote342 views1 answer
How to install mysql 8.0 windows service
SQL
0 vote360 views1 answer
Connecting mySQL to STS
SQL
0 vote345 views1 answer
Connecting to my cloud sql server with c#
SQL
4 votes327 views1 answer
Create column mysql terminal
SQL
0 vote345 views1 answer
Mysql min value row
SQL
0 vote368 views1 answer
Mysql record group by created date count
SQL
4 votes337 views3 answers
Create database in mySQL
SQL