Search and Replace in MySQL

Often your MySQL database is so large that if you want to find and replace a given entry, it will take days. This is when this simple snippet comes handy: