Forum Moderators: open

Message Too Old, No Replies

edit multiple records simultaneously in phpmyadmin

How?

         

leafgreen

12:33 am on Jan 10, 2008 (gmt 0)

10+ Year Member



Hi there! I want to edit multiple records simultaneously in phpmyadmin. In a table "x", I want to change all the values in one particular field to one different value. How?
I am a 95% newbie in phpmyadmin.
TIA! ;)

leafgreen

7:34 am on Jan 10, 2008 (gmt 0)

10+ Year Member



I got the answer (for the benefit of future readers)

UPDATE x SET COLUMN_NAME = 'Someothervalue'
WHERE COLUMN_NAME = 'Thevalue'