Mysql Archives - PHP Blog

Find-replace text in mysql field

November 13, 2017

Syntax :

update table set field_name = replace(field_name, 'old_text', 'new_text') 
where instr(field_name, 'old_text') > 0;

1 2	update table set field_name = replace(field_name, 'old_text', 'new_text') where instr(field_name, 'old_text') > 0;

Example :

UPDATE `news_feed` SET news_title = REPLACE(news_title, 'News', 'bar') WHERE  
INSTR(news_title, 'News') > 0;

1 2	UPDATE `news_feed` SET news_title = REPLACE(news_title, 'News', 'bar') WHERE INSTR(news_title, 'News') > 0;