lundi 11 juillet 2016

MySQL - FIND_IN_SET , GROUP_CONCAT Problems

I'm having an issue with a query I wrote for a plugin I developed for CS:GO.

I'm using the following query:

SELECT FIND_IN_SET(total, (SELECT GROUP_CONCAT(total ORDER BY total DESC) FROM t_cache WHERE total != 0)) AS rank, steamID, total FROM t_cache

As shown in the image below, it only processes the first 129 people, and fails to FIND_IN_SET the rest of the users where the points != 0.

Image

I'd like to know if there's a limit for any of the functions I used; and if it can be fixed.

Aucun commentaire:

Enregistrer un commentaire