Sometimes we need to do a simple find and replace on our data. But how do you do it in MySQL? The good news is, MySQL has REPLACE function that can help you to perform a simple find and replace with the help of UPDATE command. This is very useful when you need to change instances of http:// of your domain to https:// when you purchase a SSL. Or maybe when you just need to remove accidental Lorem Ipsum text …