/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 vote138 views1 answer
Mysql select smaller of two values
SQL
0 vote137 views1 answer
Windows services sql
SQL
0 vote138 views1 answer
Alter precision
SQL
8 votes142 views1 answer
How to check mysql version in xampp
SQL
1 vote128 views3 answers
Mariadb add foreign key
SQL
0 vote145 views1 answer
Mysql url data type
SQL
1 vote153 views1 answer
Lpad function in sql oracle
SQL
0 vote140 views1 answer
UNION ALL LEFT JOIN
SQL
0 vote140 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
0 vote162 views1 answer
Flask sqlalchemy session delete
SQL