How to do mysql find replace. So today, we have a need to modify entries in our mysql database. We need to find a pattern (a word) on each record and replace with another pattern, so its like find and replace.
unfortunately, this cannot be done with ordinary update command 🙁 as it will replace the whole content.
so the solution is using replace function on mysql to do mysql find and replace. the syntax can be:
update [table_name] set [field_name] = replace( [field_name], '[string_to_find]', '[string_to_replace]' );
thank you for visiting, hope this helps
picture from w3resource