Why is it not possible to "SELECT" Data as parameters for certain clauses like LIMIT?
this is the way LIMIT can be done in MySQL using variable parameters:

SET @skip=1; SET @numrows=5;
PREPARE STMT FROM 'SELECT * FROM tbl LIMIT ?, ?';
EXECUTE STMT USING @skip, @numrows;


In the place where it says SET @skip=1, One can also write SET @skip=(SELECT 1).