title: mysql while loop Break equivalent
body: <p>What would be an equivalent of a break in a while loop for mysql?</p>
  
  <pre><code>  WHILE (ctr &lt; i)
    DO ......
  
      SET cnt = (SELECT COUNT(*) FROM temp_results WHERE result = "true");
      IF cnt &gt; 0 THEN
        SELECT cnt;
        BREAK;
      END IF;
  </code></pre>
  
  <p>Thanks</p>