DELIMITER $$DROP PROCEDURE IF EXISTS `sead`.`grab_id_and_name`$$CREATE PROCEDURE `sead`.`grab_id_and_name`(IN in_schema varchar(50),IN in_table varchar(50),IN in_type varchar(50))grab:BEGIN CASE in_table WHEN "person" THEN SELECT `id`, `first_name`, `last_name` FROM in_schema.in_table WHERE `type` = in_type ORDER BY last_name DESC; LEAVE grab; WHEN "business" THEN SELECT `id`, `business_name` FROM in_schema.in_table WHERE `type` = in_type ORDER BY business_name DESC; LEAVE grab; ELSE LEAVE grab; END CASE;END$$DELIMITER ;