Help with a mysql query - replacing field

[kh99]

You could change the user table with a query, but there are a bunch of other tables that have a username. I think the best thing to do would be to write a script that uses the data manager to change the username. It would basically be

for each user
   fetch userdata
   create User data manager
   set existing
   set new username
   save