MySQL – UPDATE ticket SET status_id = 6 WHERE YEAR(created) BETWEEN 2014 AND 2023;

UPDATE ticket
SET status_id = 6
WHERE YEAR(created) BETWEEN 2014 AND 2023;

UPDATE ticket
SET status_id = 6
WHERE YEAR(created) = 2023;