I have need to change over 600 (or even more) request department from one to another. We have changed users departments, but in closed requests there is still old deparments and i can't delete the old deparment befor old department is changed to new one.Is there any 'refresh' command to mysql database for this?
Anyone knows good tip for this?