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 |
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. |