XF 1.1 How to change one username by msql queries?

Barbossa

Active member
Hi,

How can I change username let us say "Tom" into "Jerry"? I want to do this through mysql queries.

Thanks in advance.
 
It would be something like this:

Code:
update xf_user set username = 'Jerry' where username = 'Tom';

Disclaimer: I've never changed a username this way before, but I believe the above SQL should be correct. If for some reason it doesn't work properly, you can always just change it back with a similar query.
 
Top Bottom