title: MySQL function return more than 1 row
body: <p>I'd like to write a MySQL stored function that returns multiple rows of data.  Is this possible?  It seems to be locked at 1 row -- can't even return <strong>0</strong> rows.</p>
  
  <p>For example</p>
  
  <pre>
  DELIMITER //
  
  create function go()
  
  RETURNS int
  deterministic
  NO SQL
  
  BEGIN
  
  return null ; -- <b>this doesn't return 0 rows!  it returns 1 row</b>
  -- return 0 ;
  
  END //
  
  DELIMITER ;
  
  </pre>
  
  <p>Returning <code>null</code> from a MySQL stored proc though, doesn't return 0 rows.. it returns 1 row with the value <code>null</code> in it.</p>
  
  <p>Can I return 0, or more than 1 row from a MySQL function, how?</p>