d-I❄

discord.js - Imagine ❄•3y ago•

3 replies

Greg

Mysql ORDER BY ... DESC

Hello !

I am because I need your help, logic lol.

I've created a ranking system with points, so far so good, I'm using MySql and here's my query :

SELECT * FROM classementquizz WHERE serverId = "${interaction.guildId}" ORDER BY points DESCSELECT * FROM classementquizz WHERE serverId = "${interaction.guildId}" ORDER BY points DESC

But there's a problem: MySql isn't sorting the points correctly, so a screen will be attached. I heard that 15 is less than 2, I didn't know.. haha.

I don't really understand and I can't find my solution.

Thanks a lot!

Translated with www.DeepL.com/Translator (free version)

(PS : I'm on D.JS v14.9.0)