Personally I would use the advanced search and select the department in the drop down. Then click select all, click delete. If you have a ton of tickets in that department that you might need to do a few pages. This is the cleanest way to do this.If you're hell bent on doing it via MySQL then the first thing that you would want to do is take a look at your department table and get the dept_id of the department that you want to delete all the tickets. Once you have it, you can match the tickets in your ticket table. You can then do something likeDELETE FROM ost_ticket WHERE dept_id = #Note: this will NOT remove tickets data such as attachments, messages, notes, form data, etc. You should really figure out how to clean up that data to if you want to do it via the database. I would not do it this way.