title: Change visibility of all simple products
body: <p>I'm trying to change visibility of all SIMPLE-only products via SQL.</p>
  
  <p>Here is how I select all values of visibility attribute:</p>
  
  <pre><code>SELECT * FROM `catalog_product_entity_int` WHERE attribute_id = 102
  </code></pre>
  
  <p><code>catalog_product_entity_int</code> table has <code>entity_id</code> column which is product entity ID, and <code>value</code> that should be changed to <code>1</code> for all simple products.</p>
  
  <p>Here is how I select all simple products:</p>
  
  <pre><code>SELECT * FROM `catalog_product_entity` WHERE `type_id`= 'simple'
  </code></pre>
  
  <p>What I can't do, is write query that would update <code>value</code> column of <code>catalog_product_entity_int</code> for all simple products.</p>