Как сортировать текстовые поля с помощью чисел и маркеров

У меня есть следующая таблица:

 +----+-----------------------------------------+----------+
 | id | sort                                    |  channel |
 +----+-----------------------------------------+----------+
 | m2 | ["m2","1","2","11","m4","m3","m5","m1"] | E        |
 | 2  | ["m2","1","2","11","m4","m3","m5","m1"] | H2       |
 | 1  | ["m2","1","2","11","m4","m3","m5","m1"] | H1       |
 | 11 | ["m2","1","2","11","m4","m3","m5","m1"] | H3       |   
 | m4 | ["m2","1","2","11","m4","m3","m5","m1"] | S1       |
 | m3 | ["m2","1","2","11","m4","m3","m5","m1"] | C3       |
 | m5 | ["m2","1","2","11","m4","m3","m5","m1"] | M4       |
 | m1 | ["m2","1","2","11","m4","m3","m5","m1"] | G6       |
 +----+-----------------------------------------+----------+

Использование MySQL-запроса:

 SELECT id, sort, channel FROM (SELECT s.id, c.sort, s.channel FROM streams s, channels c WHERE JSON_SEARCH(s.bouquet, 'one', 1) IS NOT NULL AND JSON_SEARCH(c.bouquet, 'one', 1) IS NOT NULL AND JSON_SEARCH(c.sort, 'one', s.id) IS NOT NULL UNION SELECT m.marker, c.sort, m.channel FROM markers m, channels c, streams s WHERE JSON_SEARCH(m.bouquet, 'one', 1) IS NOT NULL AND JSON_SEARCH(c.bouquet, 'one', 1) IS NOT NULL AND JSON_SEARCH(c.sort, 'one', m.marker) IS NOT NULL) ch ORDER BY LOCATE(id, CONCAT("'", sort, "'"));

Я получил приведенный выше результат таблицы, и мне нужно отсортировать идентификатор, используя поле сортировки... поэтому вывод должен быть:

| id |
------
  m2
  1
  2
  11
  m4
  m3
  m5
  m1

Я думаю, что проблема в следующем: ORDER BY LOCATE(id, CONCAT("'", sort, "'")) но я пытаюсь изменить запрос без желаемого результата... что мне нужно сделать, чтобы получить более правильный результат?