Monatliche SQL-Updates

UPDATE page_title SET page_title = REPLACE(page_title,'Februar 2017','März 2017');
UPDATE nodewords SET content = REPLACE(content,'Februar 2017','März 2017') WHERE name='page_title';
UPDATE nodewords SET content = REPLACE(content,'28.02.2017','31.03.2017') WHERE name='description';

UPDATE page_title SET page_title = REPLACE(page_title,'Februar 2017','März 2017')
UPDATE page_title SET page_title = REPLACE(page_title,'März 2017','April 2017')
UPDATE page_title SET page_title = REPLACE(page_title,'April 2017','Mai 2017')
UPDATE page_title SET page_title = REPLACE(page_title,'Mai 2017','Juni 2017')
UPDATE page_title SET page_title = REPLACE(page_title,'Juni 2017','Juli 2017')
UPDATE page_title SET page_title = REPLACE(page_title,'Juli 2017','August 2017')
UPDATE page_title SET page_title = REPLACE(page_title,'August 2017','September 2017')
UPDATE page_title SET page_title = REPLACE(page_title,'September 2017','Oktober 2017')
UPDATE page_title SET page_title = REPLACE(page_title,'Oktober 2017','November 2017')
UPDATE page_title SET page_title = REPLACE(page_title,'November 2017','Dezember 2017')
UPDATE page_title SET page_title = REPLACE(page_title,'Dezember 2017','Januar 2017')

Suchen:
SELECT * FROM page_title WHERE page_title LIKE '%August%'

Nodewords Modul:
Pagetitle
UPDATE nodewords SET content = REPLACE(content,'Januar 2017','April 2017') WHERE name='page_title'

Metabeschreibung:
UPDATE nodewords SET content = REPLACE(content,'31.01.2017','28.02.2017') WHERE name='description';

Keywords:
UPDATE nodewords SET content = REPLACE(content,'2017,','2018,') WHERE name='keywords';
UPDATE nodewords SET content = REPLACE(content,'2017','2018,') WHERE name='og:title';

SELECT * FROM nodewords WHERE content LIKE '%2017%'

UPDATE nodewords SET content = REPLACE(content,'ion 2017','ion 2018,') WHERE name='dcterms.title'