MYGSG - Nicholas S Posted July 29 Share Posted July 29 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 Share Posted July 29 1 hour ago, 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 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 Author Share Posted July 30 9 hours ago, edvancombr said: Simple: UPDATE `tbltickets` SET `status`='Closed' WHERE `status`='Open'; 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.