title: Update one database with info from another
body: <p>I have this query</p>
  
  <pre><code>SELECT pu.payroleId, u.userId, u.firstName, u.lastName
  FROM users AS u, payrole_users AS pu
  WHERE pu.firstName = u.firstName
  AND pu.lastName = u.lastName
  LIMIT 0 , 60
  </code></pre>
  
  <p>Which selects all <code>userId</code>'s from the <code>users</code> table if the names matches the names in the <code>payrole_users</code> table (if I've got the query right!). What I need is: for each <code>userId</code>, I need to update the <code>payrole_users.intranetId</code> field. Is this possible to do with just one query or would I need to store all these as an array and then loop through the array after and then update it?</p>