Eine neue Kampagne kann man einfach auf Grundlage einer bestehenden anlegen. Einfach im folgenden Feld "Kampagne" den zu kopierenden Namen eintragen, kopieren und anschließend Bild-Daten, Priorität sowie Zeit-Daten anpassen oder neu erstellen...
/*
#vorfiltern
select campaign from plusinfo_zeitkampagne
where campaign REGEXP '[123456789][123456789]_'
AND campaign <> 'standard'
AND campaign not LIKE '%woche%'
AND campaign not LIKE '%montag%'
AND campaign not LIKE '%dienstag%'
AND campaign not LIKE '%mittwoch%'
AND campaign not LIKE '%donnerstag%'
AND campaign not LIKE '%freitag%'
AND campaign not LIKE '%samstag%'
AND campaign not LIKE '%sonntag%'
AND campaign not LIKE '%stunde%'
AND campaign not LIKE '%monat%'
AND campaign not LIKE '%month%'
AND campaign not LIKE '%mond%'
AND campaign not LIKE '%Flex%'
AND campaign <> 'test'
AND campaign NOT LIKE '%Weihnachtskal%'
;*/
UPDATE `plusinfo_zeitkampagne` a
SET campaign = concat (a.MONTH,a.DAYOFMONTH,'_',campaign)
WHERE
campaign REGEXP '[123456789][123456789]_'
AND campaign <> 'standard'
AND campaign not LIKE '%woche%'
AND campaign not LIKE '%montag%'
AND campaign not LIKE '%dienstag%'
AND campaign not LIKE '%mittwoch%'
AND campaign not LIKE '%donnerstag%'
AND campaign not LIKE '%freitag%'
AND campaign not LIKE '%samstag%'
AND campaign not LIKE '%sonntag%'
AND campaign not LIKE '%stunde%'
AND campaign not LIKE '%monat%'
AND campaign not LIKE '%month%'
AND campaign not LIKE '%mond%'
AND campaign not LIKE '%Flex%'
AND campaign <> 'test'
AND campaign NOT LIKE '%Weihnachtskal%' ;
# mehrere Zeilen bearbeiten