For avatars it would be something like this I believe

SQL Query
UPDATE ubbt_USER_PROFILE SET USER_AVATAR = replace(USER_AVATAR, 'http://www.yourdomain.com/old_path/images/', 'http://www.yourdomain.com/new_path/images/')

Last edited by gliderdad; 02/18/2011 8:13 PM.