[BroZeus]

Either convert the Column type to an integer type(this option is better in my opinion)
Or
Use this query

PHP код:

SELECT playerName,playerScore FROM playerdata where CONVERT(playerscore, SIGNED INTEGER) > 100 order by ORDER BY CONVERT(playerscore, SIGNED INTEGER) desc LIMIT 10 


You can avoid using `` around column names as long as it is not an MySQL reserved keyword or as long as the column name doesn't have any space in its name.
And also LIMIT 0,10 is same as LIMIT 10 so use LIMIT 10 as it will make query smaller.