How to stop and return from a stored procedure

[ZH LIN]

Dear all,

This question is regarding MySQL stored procedure.

I would like to stop and return from the middle of a stored procedure (SP). As SP does not have a RETURN command, how can I do this?

Here is an example:

create procedure test()
begin
...
...
return; <-- how to do something like this?
...
...
end
//

Thank you!

[Twey]

You can always use IF.