php - Wordpress Mysql database find and replace - Replace only content based on parent -


not super skilled @ mysql commands. used running commands in mysql similar

update wp_posts set post_content = replace (post_content,'item replace here','replacement text here');  

for finding old urls , various small pieces of content. command searches of posts, , finds/replaces. want argument finds/replaces content based on parent. i'm trying effect of:

update wp_posts  set post_content  post_parent = 4860 = replace (post_content,'old content','new content'); 

without luck. doing wrong?

update wp_posts set post_content = replace (post_content,'old content','new content') post_parent = 4860;


Comments

Popular posts from this blog

java - WrongTypeOfReturnValue exception thrown when unit testing using mockito -

php - Magento - Deleted Base url key -

android - How to disable Button if EditText is empty ? -