Return a count of number of rows before desired row.

[Simurgh]

Anyone know how? find_in_set doesn't seem to be able to do what I want since I am not searching through an array but am actually running a query.
What I really want is to be able to select all until something = something. I've searched the realm of google but cannot come up with anything useful, and so I am wondering if maybe I don't know the right words to be looking for.

[guelphdad]

you will have to elaborate with an example then because otherwise your question does not provide enough detail to go on.