<div dir="ltr">Drupal Mavens,<br><br>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".<br>
<br>I was about to write a simple sql query to implement in phpMyAdmin but thought I'd come here first (<i>and</i> back up the db). <br><br>I'm seeing uid in two tables: node and node_revisions. Does UID exist anywhere else?<br>
<br>Also, would I be fine with just changing it in the node_revisions table?<br><br>Thanks,<br><br>Shai<br></div>