mysql find replace wordpress posts content

update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, ‘Text to search, ‘Text to replace it with’);

UPDATE wp_posts SET post_content = REPLACE (
post_content,
'Item to replace here',
'Replacement text here');

To Search For a Text Query Only

SELECT * FROM wp_posts WHERE (post_content LIKE ‘%TEXT-TO-FIND-GOES-HERE%’);

UPDATE wp_posts SET post_content = REPLACE (  post_content,  ‘text to find here’,  ‘text to replace here’);

Command Line

mysql -u username -ppassword use mywordpress_table; UPDATE wp_posts SET post_content = REPLACE (  post_content,  ‘text to find here’,  ‘text to replace here’);

In Phymyadmin wordpress replace site internal links in posts

UPDATE `2xpwp_26_posts` SET `post_content` = REPLACE(`post_content`, ‘beta.sarkariplex.com’, ‘sarakariresultz.in’) WHERE `post_content` LIKE ‘%beta.sarkariplex.com%’ COLLATE utf8mb4_bin;