osTicket – UPDATE ticket

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

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

UPDATE tbl_ticket
SET status_id = 6
WHERE YEAR(created) = 2023 AND MONTH(created) = 01;