#Mysql ORDER BY ... DESC

3 messages · Page 1 of 1 (latest)

high niche

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 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)

zealous arrowBOT
  • Consider reading #how-to-get-help to improve your question!
  • Explain what exactly your issue is.
  • Post the full error stack trace, not just the top part!
  • Show your code!
  • Issue solved? Press the button!
  • ✅ Marked as resolved by staff
tiny cipher

looks like the points column is a string, not a number