Cacher is the code snippet organizer for pro developers

UPDATE shortener_dynamic_links SET short_url = REPLACE(short_url, 'adibm.com/mzyv/', 'adibm.com/app7/') WHERE campaign=4227

UPDATE shortener_dynamic_links SET short_url = REPLACE(short_url, 'adibm.com/ryvq/', 'adibm.com/app15/') WHERE campaign=4956

UPDATE shortener_dynamic_links SET short_url = REPLACE(short_url, 'adibm.com/vmz4/', 'adibm.com/app16/') WHERE campaign=4957

UPDATE shortener_dynamic_links SET short_url = REPLACE(short_url, 'adibm.com/2z45/', 'adibm.com/app18/') WHERE campaign=5488

UPDATE shortener_dynamic_links SET short_url = REPLACE(short_url, 'adibm.com/9748/', 'adibm.com/esw/') WHERE campaign=5495

UPDATE shortener_dynamic_links SET short_url = REPLACE(short_url, 'adibm.com/874o/', 'adibm.com/eswe/') WHERE campaign=5494