• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Help Command phpmyadmin to change name

dervin13

Active Member
Joined
Apr 26, 2008
Messages
459
Solutions
1
Reaction score
28
Hi can anyone help me in use a command in phpmyadmin to change all accounts with a word in the begin, for example.


I have accounts 353535, 363636, 373737 and i want to use a command to all my accounts change to TEST353535, TEST363636, TEST373737.

how to update this accounts? thanks
 
Try this:

UPDATE `nameYOURdatabase`.`accountsYOURtable` SET `name` = 'TEST353535' WHERE `name` = '353535';
 
Back
Top