Wordpress MySQL codes update excerpt content meta guid
WordPress MySQL codes update excerpt content meta guid. Use estes códigos para substituir palavras, urls etc no conteúdo (content) e enxertos (excerpt) do blog wordpress:
update wp_options set option_value=replace(option_value,'OLD URL','NEW URL') where option_value like "%OLD URL%";
update wp_posts SET guid=replace(guid, 'OLD URL','NEW URL');
update wp_posts SET post_excerpt=replace(post_excerpt, 'OLD URL','NEW URL');
update wp_posts SET post_content=replace(post_content, 'OLD URL','NEW URL');
update wp_postmeta SET meta_value=replace(meta_value, 'OLD URL','NEW URL');