mysql find replace 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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.