mySQL Syntax for reassociating articles to a uid

[Chelle]

Hi all,

I'm trying to put together some mySQL statements that will re associate articles written to a user whose uid changed. 

I'm good for the posts, pms, it's just that I'm still getting familiar with the TP additions.  From the looks of it, I need to address articles and shouts in the shoutbox [but it looks like I can change to the new id via the DB, and this isn't as important]

From looking at the table, this should be all I need, right?

Code Select Expand


UPDATE tableprefix_tp_articles SET authorID = 'newmemberid' WHERE authorID = 'oldmemberid';

[Chelle]

Just to follow up, this worked when I tested it on a test site a few times over for anyone else that would need to re-associate things.