MYGSG - Nicholas S Posted July 29, 2024 Share Posted July 29, 2024 Hi all, I was just hoping someone could help out and provide an SQL Query so I can mass close all open tickets. My WHMCS had a backup installed back onto the system, and now we have over 2000 open tickets. I appreciate your help. Best regards, Nick 0 Quote Link to comment Share on other sites More sharing options...
edvancombr Posted July 29, 2024 Share Posted July 29, 2024 On 7/29/2024 at 1:13 PM, MYGSG - Nicholas S said: Hi all, I was just hoping someone could help out and provide an SQL Query so I can mass close all open tickets. My WHMCS had a backup installed back onto the system, and now we have over 2000 open tickets. I appreciate your help. Best regards, Nick Expand Simple: UPDATE `tbltickets` SET `status`='Closed' WHERE `status`='Open'; 0 Quote Link to comment Share on other sites More sharing options...
MYGSG - Nicholas S Posted July 30, 2024 Author Share Posted July 30, 2024 On 7/29/2024 at 2:30 PM, edvancombr said: Simple: UPDATE `tbltickets` SET `status`='Closed' WHERE `status`='Open'; Expand Hi edvancombr, thanks I’ll try this. best regards, Nick 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.