SQL Query
update ubbt_USER_PROFILE
SET USER_EXTRA_FIELD_1 = REPLACE(USER_EXTRA_FIELD_1, 'http://domain_name.org/updtform1.cfm?id=', '')

assumes the same thing is up front for every one and that the only difference is AFTER the = sign