[support] Mass Changing UID

[Shai Gluskin]

Drupal Mavens,

On a site with about 600 nodes I need to change the node author on about 300
of them. It's very straightforward in that everything that is written by
uid="2" needs to change to uid="4".

I was about to write a simple sql query to implement in phpMyAdmin but
thought I'd come here first (*and* back up the db).

I'm seeing uid in two tables: node and node_revisions. Does UID exist
anywhere else?

Also, would I be fine with just changing it in the node_revisions table?

Thanks,

Shai
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20080805/63dd6299/attachment.htm