mysql - Get top 10 items based on certain register using SQL -

Usage: MYSQL

Therefore, I have this problem. I have a table called TWLUser , And this table has a level column, so I have to get a user level, for example,

id: 1
User: Pancho Villa
Level: 15.

So I need to get 9 registers which is below its level and I have no idea how ... So this is an example, I get ID ID: 1 User: Pancho Villa Status: 15 ID: 25 User: Emilion Zapata Level: 15 ID: 14 ​​User: Perforio Dive Level: 14 ID: 7 Users : Sub Commands Marcos & lt; Br> Level: 13

& amp; 6 more results

Try this SQL

  User, level at TblUser where level is & lt; = (TblUser WHERE user = 'five villa' from SELECT level) and user! = Level DISC limit 9 based on 'Puncho Villa'