You should not update custom field values using Database. You can use bulk change functionality in Jira UI. You can read more here
I guess there is the jira.issue.editable property for the closed status in your workflow. Change the property to jira.permission.edit.group.1 with value jira-administrators (I guess you are a Jira administrator?). Publish the workflow and you will be able to bulk change the issues.
Hi all! My name is Miles and I work on the Marketplace team. We’re looking for better ways to recommend and suggest apps that are truly crowd favorites, so of course we wanted to poll the Community. ...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs