MySQL equivalent of str_replace | Search and Replace

A great little time saving tip when doing database management, or any sort of migrations within domains that might require you to modify a certain part of a string in a MySQL column.
The issue:
You have an online store that stores all the products in a MySQL table called ‘products’, your images are hard coded links [...]