# Bulk REPLACE Firefox bookmarks
UPDATE moz_places
SET url = REPLACE (
    url,
    'http://newvegas.nexusmods.com/',
    'http://www.nexusmods.com/newvegas/'
)
WHERE
    url LIKE 'http://newvegas.nexusmods.com/%'
AND (
    (
        SELECT
            COUNT(*)
        FROM
            moz_places mp
        WHERE
            mp.url = REPLACE (
                moz_places.url,
                'http://newvegas.nexusmods.com/',
                'http://www.nexusmods.com/newvegas/'
            )
    ) = 0
);