MySQL REPLACE

UPDATE tdurl_1 SET URL = REPLACE(URL, 'http://www.tdurl.com/','http://tdurl.com/');