Cambiar URL en Wordpress

Es fundamental cuando se cambia de dominio y no te se cambian todos los enlaces del WordPress

mysql -u root
show databases;
use wp_database;
show tables;


describe wp_options;
+--------------+---------------------+------+-----+---------+----------------+
| Field        | Type                | Null | Key | Default | Extra          |
+--------------+---------------------+------+-----+---------+----------------+
| option_id    | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| option_name  | varchar(191)        | NO   | UNI |         |                |
| option_value | longtext            | NO   |     | NULL    |                |
| autoload     | varchar(20)         | NO   |     | yes     |                |
+--------------+---------------------+------+-----+---------+----------------+
select option_name from  wp_options;  
                                                                   |
| home                                                                |
| siteurl     
select option_name, option_value from  wp_options where option_name="siteurl";
UPDATE  wp_options  SET option_value='http://192.168.1.100/wordpress' WHERE option_name='siteurl';

select option_name,option_value  from  wp_options where option_name="home";
UPDATE  wp_options  SET option_value='http://192.168.1.100/wordpress' WHERE option_name='home';

Cambia el contenido de las paginas
UPDATE wp_posts SET guid=          replace (guid,'http://192.168.0.100','http://192.168.1.100');
UPDATE wp_posts SET post_content = replace(post_content, 'http://192.168.0.100', 'http://192.168.1.100');

https://www.nerion.es/soporte/cambiar-url-en-wordpress/
http://mysql.conclase.net/curso/?sqlfun=REPLACE