Title: MySQL via phpmyadmin
Last modified: August 18, 2016

---

# MySQL via phpmyadmin

 *  [Roar](https://wordpress.org/support/users/rori/)
 * (@rori)
 * [21 years, 6 months ago](https://wordpress.org/support/topic/mysql-via-phpmyadmin/)
 * Hi.
    I am hosted at Dreamhost, fwiw. I have phpmyadmin. I need to change post_author
   in table wp_posts on 1500 records from 3 to 1. Anyone have any help they can 
   offer on this?

Viewing 4 replies - 1 through 4 (of 4 total)

 *  [john1000](https://wordpress.org/support/users/john1000/)
 * (@john1000)
 * [21 years, 6 months ago](https://wordpress.org/support/topic/mysql-via-phpmyadmin/#post-113619)
 * As far as i know you cant…
    So you wanna change someones id into yours ? Well
   you cant…just by hand… Or by list ….set to 30 or higher,then click on top click
   post author …then select the ones you wanted to change …and at the bottom you
   see…….With selected….click the pencil (to edit) and and then on the new page 
   you get change all the 3 to the 1 That would take you a half day.
 *  [adsworth](https://wordpress.org/support/users/adsworth/)
 * (@adsworth)
 * [21 years, 6 months ago](https://wordpress.org/support/topic/mysql-via-phpmyadmin/#post-113626)
 * Hi Rori,
    if the 1500 records are the only ones that that have an author_id of
   3. Then the following SQL statement will do the trick. If you don’t want all 
   records with an author_id of 3 to be changed you’ll have todo it manually or 
   find another criteria which is the same on all records that you want to change:
   Use the following SQL Statement at your own risk, this is typed of off my head
   I didn’t check if this works, I don’t want to hear any complains if it blows 
   your posts (it won’t delete them): UPDATE wp_posts SET author_id=1 WHERE author_id
   =3; This will change all records in the wp_posts with an author_id of 3 to have
   an author_id of 1 and isn’t reversible. Regards Adi
 *  Thread Starter [Roar](https://wordpress.org/support/users/rori/)
 * (@rori)
 * [21 years, 6 months ago](https://wordpress.org/support/topic/mysql-via-phpmyadmin/#post-113629)
 * Actually, I want to change all IDs to mine.
    I made an error on the initial MT
   import so now I have two authors named Rori.
 *  [thepete](https://wordpress.org/support/users/thepete/)
 * (@thepete)
 * [21 years, 6 months ago](https://wordpress.org/support/topic/mysql-via-phpmyadmin/#post-113901)
 * I had the same problem and the above solution… _worked for me, too!_
    Thanks,
   Adsworth!! And thanks to Rori, too for posting this thread in the first place!
   🙂

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘MySQL via phpmyadmin’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 4 participants
 * Last reply from: [thepete](https://wordpress.org/support/users/thepete/)
 * Last activity: [21 years, 6 months ago](https://wordpress.org/support/topic/mysql-via-phpmyadmin/#post-113901)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics