python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - find-in-set

Add second column to order by mysql in a group_concat

I have this query I made based on someone else question here. SELECT *, FIND_IN_SET( score, ( SELECT GROUP_CONCAT( score ORDER BY score ASC) FROM EventPlayerResult WHERE eventId = 'EventTest0') ) AS p...
test-img

DrDoom

mysql

sql-order-by

group-concat

find-in-set

Votes: 0

Answers: 1

Latest Answer

You should use the player and not the score inside GROUP_CONCAT() so that the players are ranked by score first and then by energyLeft. Assuming there is a column like player_id in the table: SELECT *...
test-img

forpas

Posts

Questions

Blogs

Jobs