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;

Leave a Reply

Your email address will not be published. Required fields are marked *

Shares