title: select count(*) multiple rows and display result
body: <p>I have to do an UPDATE table that includes a SELECT COUNT but that takes way too long. 
  That was my original query </p>
  
  <pre><code> UPDATE list SET count = 
   (SELECT COUNT(*) FROM set_1 WHERE set_1.start BETWEEN list.start AND list.end); 
  </code></pre>
  
  <p>I just have 100 rows to update so I was thinking of just do a select count and display it on screen. And then I'll copy/paste the result on my excel spreadsheet.</p>
  
  <p>I was intended to do this, but it returns only one number (and not 100 rows of number)</p>
  
  <pre><code> SELECT COUNT(*) FROM set_1,list WHERE set_1.start BETWEEN list.start AND list.end;
  </code></pre>
  
  <p>But that doesn't work it returns one big number of all the SELECT COUNT together .. </p>
  
  <p>Anyone can help me out with this ? </p>