MySQL via phpmyadmin

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.

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

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.

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! ??