How do I Bulk Edit One Field in a db Table in phpMyAdmin??

ShuggsRR · 10-23-2006, 01:41 PM

Make a long story short... I imported my users and posts from one program to another. Now in my user table thier birthdays are all set to 00-00-0000 and therefore no one can log in. All I need to do is put in any logical value like 01-01-1980 and it will work again. It is takeing me FOREVER to do each user individually.

I logged into phpMyAdmin and went to my database. From there I went to the table and I see the 1000 users listed that need thier birthdays changed.

How do I change them in bulk? Im so lost!

Thanks to anyone that can help me.

Dragineez · 10-23-2006, 01:54 PM

I'm not positive on the exact syntax, but an update query should do the trick.

Quote:

UPDATE [tablename] SET [fieldname] = #01-01-1980#