title: MySQL copy value of field in one column to another field in the same column of table
body: <p>I wish to copy the value of a field in a column to another field in the same column.  My reasoning is that field is ctrl-a delimited and I don't know how to input that using an insert manually.</p>
  
  <p>I tried:</p>
  
  <pre><code>update table_foo
  set my_column =
  (
     select my_column
     from table_foo
     where id=5
  )
  where id=1;
  </code></pre>
  
  <p>this gives me:</p>
  
  <pre><code>ERROR 1093 (HY000): You can't specify target table 
  </code></pre>
  
  <p>Or if you know how to insert a CTRL+A delimited value as well that would solve my problem. Thanks!</p>