I have a column "etype" which stores enum('r', 'p').

So with each selection I want to extend the row number until the number of etype->'p' will reach some number, for instance 10.

If I use LIMIT 10, the total number of rows will be 10, but there is no guarantee that all of them in the field 'etype' will be 'p'. But I want exactly 10 'etype'->'p's, in this case the number of total rows is unknown.

Thnx in advance