title: need to move data from one field to another, within the same table
body: <p>I want to move all data from field_id_41 into field_id_380, where weblog_id = 191</p>
  
  <p>Those two fields belong to the same table: exp_weblog_data</p>
  
  <p>I do not want to run anything without asking here, I started to put this together:</p>
  
  <pre><code>UPDATE 
    exp_weblog_data 
  SET 
    field_id_380 = (SELECT field_id_41 FROM exp_weblog_data 
    WHERE (field_id_41 != '' and weblog_id = 191)) 
  WHERE 
    weblog_id = 191
  </code></pre>