MySQL Update URL and url_archive UPDATE table SET url_archive = URL WHERE YEAR(dt_create) = 2022; UPDATE table SET URL = '' WHERE YEAR(dt_create) = 2022;