Conditional Limit?

[Kees van der Sluijs]

I have need for something like a conditional limit. What I want is to limit the results of the query to the first X elements that satisfy some condition, e.g.:

Select *
FROM Table1
ORDER BY Column1
Limit 10 WHERE Column2="cond2"

So I want to have a result set with X results (possible >10) where exactly 10 results satisfy the given condition. The elements that do not satisfy the condition should be in the result, but should not make the limit stop.

Does anyone have a clue if and how this can be done in mysql?

-edit- I am afraid I posted this in the wrong forum. I actually wanted to post this in the newbie forum. Sorry.



Edited 1 time(s). Last edit at 04/06/2008 06:27AM by Kees van der Sluijs.