Replace IP String query

[jarvis]

Problem: I have switched hosts for all of my web images. Instead of going through manually and finding links, I was hoping someone might point me in the right direction of creating a MySQL query and statement to find all instances of IP address x.x.x.x or url http://domain.com and replace with IP address y.y.y.y or url http://newdomain.com.

Thanks much in advance!! :D

BTW, I did use the template find and replace feature, so that part is done.

[jarvis]

Anyone? :(

[Xenon]

you may look for a hack by the sisko i think.

he released one that replaced all occurances in posts/sigs