edit multiple records simultaneously in phpmyadmin
How?
leafgreen
12:33 am on Jan 10, 2008 (gmt 0)
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)
I got the answer (for the benefit of future readers)
UPDATE x SET COLUMN_NAME = 'Someothervalue' WHERE COLUMN_NAME = 'Thevalue'
