webaka9

Untitled

Mar 29th, 2015
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.41 KB | None | 0 0
  1. # Bulk REPLACE Firefox bookmarks
  2. UPDATE moz_places
  3. SET url = REPLACE (
  4.     url,
  5.     'http://newvegas.nexusmods.com/',
  6.     'http://www.nexusmods.com/newvegas/'
  7. )
  8. WHERE
  9.     url LIKE 'http://newvegas.nexusmods.com/%'
  10. AND (
  11.     (
  12.         SELECT
  13.             COUNT(*)
  14.         FROM
  15.             moz_places mp
  16.         WHERE
  17.             mp.url = REPLACE (
  18.                 moz_places.url,
  19.                 'http://newvegas.nexusmods.com/',
  20.                 'http://www.nexusmods.com/newvegas/'
  21.             )
  22.     ) = 0
  23. );
Advertisement
Add Comment
Please, Sign In to add comment