SQL query for top 100, displayed in reverse

Question

I have a database of logos, 18K strong. Each logo has a score. I want to select the top 100 by score and display them from 100 to 1, not from 1 to 100.

My query is:

SELECT * FROM tbllogos WHERE status = 'live' ORDER BY score DESC LIMIT 100

which works fine for selecting the top 100, but the php WHILE loop then displays them from 1 to 100. I can't figure out how to swap the order so it displays 100 to 1. Changing DESC to ASC obviously isn't the answer as that selects the 100 with the lowest scores.

Answer 1

Use a subquery:

SELECT t.*
FROM (SELECT *
      FROM tbllogos
      WHERE status = 'live'
      ORDER BY score DESC
      LIMIT 100
     ) t
ORDER BY score ASC;