MySQL Find and Replace
Feb 5, 2008 · 1 minute readCategory: mysql
This is post is now quite old and the the information it contains may be out of date or innacurate.
If you find any errors or have any suggestions to update the information please let us know or create a pull request on GitHub
Its an easy thing to do though and here is the code:
update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');
note - nice syntax highlighting plugin used is mentioned here