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');