webaka/firefox bookmarks replace.sql

## firefox bookmarks replace.sql
# 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
);