Skip to content

Instantly share code, notes, and snippets.

@kevindavis
Last active August 29, 2015 14:23
Show Gist options
  • Save kevindavis/2dbbfb70dd8becf557ef to your computer and use it in GitHub Desktop.
Save kevindavis/2dbbfb70dd8becf557ef to your computer and use it in GitHub Desktop.
fixup for youtube ids
SELECT
title,
youtube_id
FROM
activities
WHERE
youtube_id = '/L7dvr5_At1Y' OR
youtube_id = '/wrALejpF-sY' OR
youtube_id = '/pheweKtzMNI' OR
youtube_id = '/uMQ8iJ4VIGk' OR
youtube_id = '/fDpiKloyppc' OR
youtube_id = '/H49Iqr1_9jU' OR
youtube_id = '/8eV3nrNVXxo' OR
youtube_id = '/HP43mvzhxZ0'
-- returns 125 rows that look like:
-- ["jose's Version Of Hawaiian Sweet Rolls", "/fDpiKloyppc"]
UPDATE activities SET youtube_id='L7dvr5_At1Y' WHERE youtube_id = '/L7dvr5_At1Y';
UPDATE activities SET youtube_id='wrALejpF-sY' WHERE youtube_id = '/wrALejpF-sY';
UPDATE activities SET youtube_id='pheweKtzMNI' WHERE youtube_id = '/pheweKtzMNI';
UPDATE activities SET youtube_id='uMQ8iJ4VIGk' WHERE youtube_id = '/uMQ8iJ4VIGk';
UPDATE activities SET youtube_id='fDpiKloyppc' WHERE youtube_id = '/fDpiKloyppc';
UPDATE activities SET youtube_id='H49Iqr1_9jU' WHERE youtube_id = '/H49Iqr1_9jU';
UPDATE activities SET youtube_id='8eV3nrNVXxo' WHERE youtube_id = '/8eV3nrNVXxo';
UPDATE activities SET youtube_id='HP43mvzhxZ0' WHERE youtube_id = '/HP43mvzhxZ0'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment