title: Checking if select statement in stored procedure returns row
body: <p>How does one check if a select statement inside a stored procedure returns any rows.</p>
  
  <pre><code>select * from creditcards;
  If sqlcod = 0 THEN
  </code></pre>
  
  <p>I'd like to do something like this for example but sqlcod doesn't seem to work in MySql.</p>