Reverse Result

[The Little Guy]

I have this query:

SELECT * FROM mp3 ORDER BY playCount DESC LIMIT 100

 

I need to select those, then reverse the selected ones, how can I do that?

[The Little Guy]

I did come up with this:

 

SELECT * FROM 
(
SELECT * FROM mp3 WHERE `status` = 2 AND `artist` != '' AND `song` != '' ORDER BY playCount DESC LIMIT 100
) 
as result ORDER BY playCount LIMIT 5

 

is there a better solution?

[fenway]

No, not really.