way to bulk edit categories?

I want to add a parent for 100+ categories. Is there a quick way of doing this or do I just have to go in and edit each individually?
I thought there would be the option to do this in wp-admin but there isn’t.
So I’ve been looking around phpMyAdmin but can’t see any way with sql. Would be nice if I could just add the parent to each cat with a line of code…