MySQL/MariaDB search and replace
This is one of those things I'm constantly forgetting, especially since I use Postgres for most of my work.
To replace the occurance of a string in a field with another, use the following. This replaces the value of the field with the value of the field where a text substitution has taken place:
MariaDB [DB]> UPDATE table -> SET field=REPLACE(field,'original','replacement');
The MariaDB site lists further details.