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 0 rows.

For example

DELIMITER //

create function go()

RETURNS int
deterministic
NO SQL

BEGIN

return null ; -- this doesn't return 0 rows!  it returns 1 row
-- return 0 ;

END //

DELIMITER ;

Returning null from a MySQL stored proc though, doesn't return 0 rows.. it returns 1 row with the value null in it.

Can I return 0, or more than 1 row from a MySQL function, how?