Desperate: BETWEEN and ORDER BY on different columns

[Joachim Berger]

Hi, is there any chance to perform a range scan and simultaneously order by another column?

In other words: What indexes do I need for performing a query like this, which uses the index and does no filesort? Is that possible?

SELECT id

FROM members

WHERE (sex = 2)
AND (birthdate BETWEEN '1980-09-01' AND '1984-09-01')

ORDER BY rnd

LIMIT 10;


Best,
Ben