Search and Replace in MySQL

I found something very handy today, search and replace on Mysql databases. You can do it on phpmyadmin or make a php script with this. After moving a wordpress site from server I discovered that all image links were broken