Passing TableName to a Stored Procedure

[Clive Morris]

I am trying to pass a table name to a stored procedure simple example code follows:

DELIMITER //
CREATE PROCEDURE myProcedure(IN tabName varchar(50))
BEGIN

SELECT tabName; -- Correctly outputs the expected value assigned to tabName

SELECT ClientID FROM tabName limit 100; -- Throws error

END //
DELIMITER ;

The first select statement displays the value of the variable as expected but the second select statement throws the error: Table 'mydatabase.tabName' doesn't exist