table name as stored procedure parameter

[shaun merifield]

I realise this topic has probably been done to death but I cant seem to find a solution which works for me.

I want to call a stored procedure thus: call GetStakeholder("tablename", "unique_identifier", id);

I then want the procedure to return all records from the specified table using the unique identifier with the specified id.

It wont work. I realise this may require prepared statements but they dont seem to do it either.

Can someone post a working example of the syntax to get this working please. So far I *think* it should follow this format:

DELIMITER $$

DROP PROCEDURE IF EXISTS `eduplan`.`GetStakeholder`$$

CREATE PROCEDURE `eduplan`.`GetStakeholder`(usingtable varchar(255), usingid varchar(255), identifier varchar(255))
/*LANGUAGE SQL
| [NOT] DETERMINISTIC
| { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
| SQL SECURITY { DEFINER | INVOKER }
| COMMENT 'string'*/
BEGIN

SELECT
*
FROM
usingtable
WHERE
usingid = identifier
LIMIT 1;


END$$

DELIMITER ;

Cheers!