[Nix92]

Hello guys, is there any option inside phpMyAdmin to rename all the rows at once... for example, i have a column named "Owner" and a row is called "Empty" i'd like to change it to No-One, but i have 300 rows that are called Empty, it would take hours to change them all one by one, and i was wondering if there was any option to rename them all at once, i was looking past hour to find that option, but no success. I'd like to get some support if possible, Thanks in advance.

[misticini]

Hello you can do for example:

Update users set owner = 'No-One' where id >=0

[Nix92]

Could u be more precise? Please.

[misticini]

go to phpmyadmin -> your_bd -> sql and execute the query that i write in post.

Update 'your_users_name_table' set Field_to_set = 'No-One' where id >=0