MySQL LIMIT with parameters

Question

How to use a LIMIT statement with parameters in MySQL?

how

SELECT * FROM someTable LIMIT variable1, variable2;

Answer 1

Try this inside SP

 SET @String1 = concat(concat(concat(concat("SELECT field1,field2 FROM table1 WHERE field3 = ",sp_var1," && field4 = "),sp_var2," LIMIT "),sp_Var_skip,","),sp_var_count); PREPARE Stmt FROM @String1; EXECUTE Stmt; SET @String1 = "" 

As an alternative

 DELIMITER $ CREATE PROCEDURE `tmp`() BEGIN PREPARE STMT FROM "SELECT * FROM users LIMIT ?,?"; END$ DELIMITER; SET @a=2; SET @b=1; CALL tmp(); EXECUTE STMT USING @a, @b; 

Read more about it here.