JD_Toims - 1:51 am on Jul 22, 2013 (gmt 0)
I haven't done this before, but the approach I would start with in mind would be to use PHP and "UPDATE Table SET col_with_network_sites='root-domain' WHERE col_with_network_sites='site-in-network" then "UPDATE Table SET root_domain_col='site-in-network'"
Hope it gives you an idea or two.
BTW Sorry no one got back to you in over a month with any ideas. I'll have to try to remember to check in here more often since I can usually at least 'throw a dart' at issues with MySQL.