title: How to order by array value inside json path mysql?
body: <p>I have a column in db table which is of a JSON type.</p>
  <p>This column will store such values:</p>
  <pre><code>column 1: [&quot;bmw&quot;, &quot;opel&quot;, &quot;audi&quot;] 
  column 2: [&quot;opel&quot;, &quot;bwm&quot;, &quot;audi&quot;]
  column 3: [&quot;audi&quot;]
  </code></pre>
  <p>the order of values is different as well as the total number but in general there is a list of valid values to be stored.</p>
  <p>On UI, there is a table with columns which can be sorted. When user clicks on a column <code>Car Brand</code>, ASC, I will need to sort the output from db based on the column values I mentioned above.</p>
  <p>I'd like to receive the following output:</p>
  <pre><code>1: [&quot;audi&quot;]
  2: [&quot;audi&quot;, &quot;bmw&quot;, &quot;opel&quot;]
  3: [&quot;audi&quot;, &quot;bmw&quot;, &quot;opel&quot;] 
  </code></pre>
  <p>I can't seem to find the solution for this using JSON path.</p>
  <p>Can anybody help me?</p>
  <p>Please do not suggest to store the values in a different way, it's not me who decides this.</p>