assuming you want to replace all these fields with empty string, it could be

update [table] set [field]=''

where [field] like '%http://dfrgcc.com/ur.php%'