MySql Query Limit based on Sub Query Value

Question

I am looking for a solution to use sub query in limit value.

Ex:

SELECT *
FROM `user`
WHERE usertype='6' LIMIT
  (SELECT count(*) FROM allowed WHERE usertype='6')

Is there any other way to use a sub Query in LIMIT. I tried the above Query but Its not working.

Do it in 2 steps: 1. select the limit from the 1-st table, 2. use it in the 2-nd query — user4035, Sep 18 '14 at 10:42
I need it to be in single query is that possible. I can do that by two different queries.. — DonOfDen, Sep 18 '14 at 10:43
possible duplicate of [Variable LIMIT Clause in MySQL](http://stackoverflow.com/questions/245180/variable-limit-clause-in-mysql) — davek, Sep 18 '14 at 10:45

davek · Accepted Answer · 2014-09-18T10:57:39.167

1

This is not possible with MySql; you have to use a stored procedure/prepared statement as workaround.

Lots of people have requested this:

but as you see from the bug listing, this is still open.

EDIT: actually, it seems to have been added in version 5.5.6:

edited Sep 18 '14 at 10:57

answered Sep 18 '14 at 10:46

davek

1 Answers1