does exists some MYSQL query for FIND and REPLACE wp_posts AND IGNORE all other wordpress and buddypress posts (buddypress-docs) and also custom post type = portfolio ? I want to find and replace only wordpress blog content and I don't want to touch other posts. I use following MYSQL query:
UPDATE wp_posts SET post_content = REPLACE (post_content,'Item to replace here','Replacement text here');
Add a WHERE clause to your query for post_type = 'post'.
UPDATE wp_posts WHERE post_type = 'portfolio' SET post_content = REPLACE (post_content,'Item to replace here','Replacement text here'); Do you mean like this? Does it ignore post_type Portfolio?
May 30, 2013 at 19:07
post_type = 'portfolio' will affect only portfolio type, I meant exactly as I typed it- post_type = 'post'. Look at the table itself and it will be obvious.
UPDATE wp_posts SET post_content = REPLACE WHERE post_type = 'post' (post_content,'Item to replace here','Replacement text here'); Sorry, I understand now, the WHERE tells what exactly will be replaced and not what will be ignored, I am new here so I can't confirm that your answer is correct
May 30, 2013 at 20:01