MySQL question - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL question (/showthread.php?tid=361435)

---

MySQL question - Nix92 - 21.07.2012

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.

---

Re: MySQL question - misticini - 21.07.2012

Hello you can do for example:

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

---

Re: MySQL question - Nix92 - 21.07.2012

Could u be more precise? Please.

---

Re: MySQL question - misticini - 21.07.2012

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

---