Update Diaspora Records for Net Narthollis

UPDATE posts
    SET diaspora_handle = SUBSTRING(diaspora_handle, 1, LENGTH(diaspora_handle)-5)
    WHERE diaspora_handle LIKE '%@diaspora.narthollis.net:3000';
UPDATE people
    SET diaspora_handle = SUBSTRING(diaspora_handle, 1, LENGTH(diaspora_handle)-5)
    WHERE diaspora_handle LIKE '%@diaspora.narthollis.net:3000';
UPDATE people
    SET url=REPLACE(url,':3000','')
    WHERE url LIKE '%diaspora.narthollis.net:3000%';
UPDATE profiles
    SET
        image_url=REPLACE(image_url,':3000',''),
        image_url_small=REPLACE(image_url_small,':3000',''),
        image_url_medium=REPLACE(image_url_medium,':3000','')
    WHERE image_url LIKE '%diaspora.narthollis.net:3000%';