All pastes #345032 Raw Edit

Someone

public text v1 · immutable
·published 2007-02-08 05:35 UTC
rendered paste body
REPLACE INTO itm_event_artist 
SELECT ies.ID AS itm_event_id, ia.id AS itm_artist_id FROM itm_events ies INNER JOIN itm_artist ia ON replace(substring(substring_index(ies.djs, ',', 1),
                         length(substring_index(ies.djs, 
                                                ',', 
                                                1 - 1)) + 1),
               ',', '') = ia.name

REPLACE INTO itm_event_artist 
SELECT ies.ID AS itm_event_id, ia.id AS itm_artist_id FROM itm_events ies INNER JOIN itm_artist ia ON replace(substring(substring_index(ies.djs, ',', 2),
                         length(substring_index(ies.djs, 
                                                ',', 
                                                2 - 1)) + 1),
               ',', '') = ia.name

REPLACE INTO itm_event_artist 
SELECT ies.ID AS itm_event_id, ia.id AS itm_artist_id FROM itm_events ies INNER JOIN itm_artist ia ON replace(substring(substring_index(ies.djs, ',', 3),
                         length(substring_index(ies.djs, 
                                                ',', 
                                                3 - 1)) + 1),
               ',', '') = ia.name

REPLACE INTO itm_event_artist 
SELECT ies.ID AS itm_event_id, ia.id AS itm_artist_id FROM itm_events ies INNER JOIN itm_artist ia ON replace(substring(substring_index(ies.djs, ',', 4),
                         length(substring_index(ies.djs, 
                                                ',', 
                                                4 - 1)) + 1),
               ',', '') = ia.name

REPLACE INTO itm_event_artist 
SELECT ies.ID AS itm_event_id, ia.id AS itm_artist_id FROM itm_events ies INNER JOIN itm_artist ia ON replace(substring(substring_index(ies.djs, ',', 5),
                         length(substring_index(ies.djs, 
                                                ',', 
                                                5 - 1)) + 1),
               ',', '') = ia.name