MySQL Stored Procedure

Is it possible to execute a MySQL and get values back?

I'm new to MVD and trying to think of all the things that I need to be able to do to properly create the apps that I'm wanting to create.

Thanks in adavance

Alan