MySQL ORDER BY不是最常见的

Question

Hello i have this table which contains users and the amount of points they have and i want to display the table starting from the users with the highest points but when i try the code below what it does is it shows the most common amount of points.

SELECT * FROM users ORDER BY points ASC

But instead of

User | Points
Bob    20
Jon    16
Abu    16
Eli    15

It does

User | Points
Jon    16
Abu    16
Bob    20
Eli    15

See shouldn't 20 be on top? it does it by most common points any help I am new to PHP

EDIT: Thanks to Hanky 웃 Panky i realized what i needed to do

ORDER BY CAST(points AS unsigned) DESC 

Is the correct way.

Answer 1

Your Points field must be a String to be interpreted that way. Cast it as a number( if you cant change data type to become a number permanently) and you are good.

SELECT * FROM users ORDER BY CAST(points AS unsigned) ASC

And for a Descending order, use DESC instead of ASC

Fiddle