MySQL sort order by array value of selected table

Question

With e.g.

ORDER BY field(id, 9, 1, 4)

I can order by 9,1,4.

Is it also possible to order by a comma separated string of the same table I am selecting?

I tried

ORDER BY field(id, aFieldFromTheTableIAmSelecting)

where aFieldFromTheTableIAmSelecting is "9,1,4"

But that does not work.

sticky bit · Accepted Answer · 2019-04-28 14:20:32Z

1

You can try find_in_set():

ORDER BY find_in_set(id, aFieldFromTheTableIAmSelecting)

answered Apr 28, 2019 at 14:20

sticky bit

37.7k12 gold badges34 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

forpas · Accepted Answer · 2019-04-28 14:20:09Z

0

You can use locate():

ORDER BY locate(concat(',', id, ','), concat(',', aFieldFromTheTableIAmSelecting, ','))

there must be no spaces inside aFieldFromTheTableIAmSelecting.

answered Apr 28, 2019 at 14:20

forpas

165k10 gold badges51 silver badges85 bronze badges