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!!

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