LinuxQuestions.org - How do I Bulk Edit One Field in a db Table in phpMyAdmin??

- Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)

- - How do I Bulk Edit One Field in a db Table in phpMyAdmin?? (https://www.linuxquestions.org/questions/linux-newbie-8/how-do-i-bulk-edit-one-field-in-a-db-table-in-phpmyadmin-494911/)

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

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.

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

Quote:

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