Indeed. This would come in very handy right about now.
I actually was able to do this in SQL Editor with a query.
UPDATE databasename.wp_usermeta SET meta_value = REPLACE(meta_value,’s:13:”administrator”;s:1:”1″;}’,’a:1:{s:6:”editor”;b:1;}’);
Thanks for the reply. I need to change all users on all sites, who are currently Admins, to be Editors.
I understand that. What I want to know is if there is a way to change the roles across the entire network. Perhaps there is a MySQL query that can do it.
Okay, so maybe I should approach this another way. Does anyone know how to change all user roles on a Multisite network without doing so directly in the database?
