modify all posts of a category to “no comments allowed”

I’m looking for a way to modify all posts of a certain category to be “no comments allowed” without going into each post settings, one by one, and modifying manually.

Perhaps a MySQL statement?

Thanks

On your posts screen, you should be able to filter by category and then select all and bulk edit to turn off comments.

Edit: Bulk actions only apply per page (e.g. 20 posts or however many you have showing), so you’ll either have to do it for each page of results or go up to screen options and increase the number of items that are showing on screen.