Help Command phpmyadmin to change name

[dervin13]

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

 

[Sigoles]

Try this:

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