Deleting specific rows

[DragonHighLord]

I have a table of scores with more than 100 entries. I want this table to have only 100 entries where the highest scores are left in place.

I'm not sure what the easiest way to do this is. COUNT(*) the table and use that number as a loop counter and after it hits 100 put in some code to delete the current entry it's on(if so how do you so that)
or can I just do a command that deletes any row over 100 after they have been ORDER BY score?

[mrhappiness]

reading http://www.mysql.com/doc/en/DELETE.html i think you can do something like

DELETE
FROM table
ORDER BY score DESC
LIMIT 100, 999999999