LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   phpmyadmin (or regular mysql) batch column edit? (https://www.linuxquestions.org/questions/linux-software-2/phpmyadmin-or-regular-mysql-batch-column-edit-203455/)

fibbi 07-10-2004 01:39 PM

phpmyadmin (or regular mysql) batch column edit?
 
hey everyone, i have a wordpress blog, but the entries i imported from my old blog got imported as a different author, and so i have about 180 entries in the wp_posts table with author id 1, and about 180 with author id 3. Is there any way i can use phpmyadmin or mysql to change every entry in the table to have the same value for author id?

Thanks,
-fibbi

Vookimedlo 07-10-2004 02:06 PM

hi,


try: UPDATE wp_posts SET id=1;

thiss will change all values in ID column to 1 in table wp_posts


All times are GMT -5. The time now is 06:18 PM.