Find/Replace via mySQL

[Mr. Pedram]

Hey,
i have a Photo Upload Center (Mihalism),dedicated to my SMF forum
my forum's users uploaded their photos in this upload center, i forced to change domain (URL) of this upload center, i did this , then all photos that inserted in my forum of course disappeared. number of photos is more than 4000 in many posts... of course i can't edit that posts and change url of these photo manually!  now the question is,

is it possible i change url of these photos via (SMF) mySQL? with a query or something else?
for e.g,

Find old url, replace with new url of this upload center
can anyone help me out?

[MrPhil]

Mr. Search says http://www.simplemachines.org/community/index.php?topic=498981.msg3502230#msg3502230 . The same general principle should hold for other tables -- find the table and field that holds the URL and use them instead of smf_messages and body.

[Mr. Pedram]

Thanks MrPhil, for Mr Search