如何在MySQL上的表中运行查找和替换

I bet you once already thought: 🤔💭

How cool would it be if I could run a "Find & Replace" on a database table...

The good news is that's totally possible. 🎉

Just have use the following query:

update <table_name> set <field_name> = replace(<field_name>,'<string_to_find>','<string_to_replace>');

Cool huh?!