But :
\nRemplacer fougere.myds.me:8080 par les-fougs.com dans les champs post_content et guid de la table wp_posts<\/p>\n
create table wp_posts_old as select * from wp_posts<\/p>\n
SELECT post_content FROM wp_posts WHERE post_content like ‘%http:\/\/fougere.myds.me:8080\/recettes%’<\/p>\n
SELECT REPLACE (post_content, ‘http:\/\/fougere.myds.me:8080\/recettes’ , ‘http:\/\/les-fougs.com\/recettes’) FROM wp_posts WHERE post_content like ‘%http:\/\/fougere.myds.me:8080\/recettes%’<\/p>\n
update wp_posts set post_content = REPLACE (post_content, ‘fougere.myds.me:8080’ , ‘les-fougs.com’) WHERE post_content like ‘%fougere.myds.me:8080%’<\/p>\n
SELECT guid FROM wp_posts WHERE guid like ‘%http:\/\/fougere.myds.me:8080\/recettes%’<\/p>\n
SELECT REPLACE (guid, ‘http:\/\/fougere.myds.me:8080\/recettes’ , ‘http:\/\/les-fougs.com\/recettes’) FROM wp_posts WHERE guid like ‘%http:\/\/fougere.myds.me:8080\/recettes%’<\/p>\n
update wp_posts set guid = REPLACE (guid, ‘fougere.myds.me:8080’ , ‘les-fougs.com’) WHERE guid like ‘%fougere.myds.me:8080%’<\/p>\n
Source :
\nREPLACE(str,from_str,to_str)<\/p>\n
Returns the string str with all occurrences of the string from_str replaced by the string to_str. REPLACE() performs a case-sensitive match when searching for from_str.<\/p>\n
mysql> SELECT REPLACE(‘www.mysql.com’, ‘w’, ‘Ww’);
\n -> ‘WwWwWw.mysql.com’
\nThis function is multibyte safe. <\/p>\n","protected":false},"excerpt":{"rendered":"
But : Remplacer fougere.myds.me:8080 par les-fougs.com dans les champs post_content et guid de la table wp_posts create table wp_posts_old as select * from wp_posts SELECT post_content FROM wp_posts WHERE post_content like ‘%http:\/\/fougere.myds.me:8080\/recettes%’ SELECT REPLACE (post_content, ‘http:\/\/fougere.myds.me:8080\/recettes’ , ‘http:\/\/les-fougs.com\/recettes’) FROM wp_posts WHERE post_content like ‘%http:\/\/fougere.myds.me:8080\/recettes%’ update wp_posts set post_content = REPLACE (post_content, ‘fougere.myds.me:8080’ , ‘les-fougs.com’) WHERE … Continuer la lecture de « Remplacement d’une valeur par une autre dans un champ »<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[35],"tags":[],"_links":{"self":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/1274"}],"collection":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/comments?post=1274"}],"version-history":[{"count":0,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/1274\/revisions"}],"wp:attachment":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/media?parent=1274"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/categories?post=1274"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/tags?post=1274"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}