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
– user4035, Commented Sep 18, 2014 at 10:42
I need it to be in single query is that possible. I can do that by two different queries.. — DonOfDen
– DonOfDen, Commented Sep 18, 2014 at 10:43

davek · Accepted Answer · 2014-09-18 10:57:39Z

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:

answered Sep 18, 2014 at 10:46

davek

23k11 gold badges80 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1