## Coller la totalite dans champs SQL de phpMyAdmin
## ATTENTION A NE PAS METTRE DE SLASH A LA FIN DES URL



# CHANGER URL DU SITE

UPDATE msf_options
SET option_value = replace (option_value, 'http://www.maymounafinance.ma', 'http://mytest.test')
WHERE option_name = 'home'
OR option_name = 'siteurl';



# CHANGER URL DES GUID (GLOBAL UNIQUE IDENTIFIER)

UPDATE msf_posts
SET guid = replace (guid, 'http://www.maymounafinance.ma', 'http://mytest.test');



# CHANGER LES URL DES CONTENUS DES ARTICLES
# (LIEN, IMAGE, DOCUMENT)

UPDATE msf_posts
SET post_content = replace (post_content, 'http://www.maymounafinance.ma', 'http://mytest.test');



# CHANGER LES URL DES DONNEES META DES POSTS

UPDATE msf_postmeta
SET meta_value = replace (meta_value, 'http://www.maymounafinance.ma','http://mytest.test');
