title: MYSQL Query not changing, updating value from value in same column
body: <p>I asked this question on another post which have me a basic query but still not working when executing the following nothing happens any ideas?</p>
  
  <pre><code>UPDATE mage_catalog_product_entity_varchar 
    SET value = (SELECT value WHERE attribute_id = 703) 
    WHERE attribute_id = 106;
  </code></pre>
  
  <p>So I am updating the value in the value column if the attribute_id column = 106 but only updating from the value column where the attribute_id column = 703</p>
  
  <p>The following query also updates 0 in the value fields corresponding to attribute_id 106</p>
  
  <pre><code>UPDATE mage_catalog_product_entity_varchar 
    SET value = (SELECT value from mage_catalog_product_entity_varchar 
    WHERE attribute_id = 703) WHERE attribute_id = 106;
  </code></pre>