title: Why is my MySQL update statement, involving 2 tables not working?
body: <p>my update statement which i was sure would work, is this:</p>
  
  <pre><code>UPDATE products SET manufacturers_id = 37 where products_id = 
  (select products_id from     products_to_categories where categories_id = 35);
  </code></pre>
  
  <p>but in PHPMyAdmin, the error i'm getting is this:</p>
  
  <pre><code>#1242 - Subquery returns more than 1 row
  </code></pre>
  
  <p>but i want more than 1 row updated. i was trying to update 100 or more in a single statement. how can this be re-written so it will work? Do i have to use a join?</p>