title: Order depending on json data in varchar field
body: <p>I have a mysql table like the following</p>
  
  <pre><code>id | name | data
  </code></pre>
  
  <p>Where <code>data</code> is holding a json object like the following:</p>
  
  <pre><code>{
      type: test,
      number: 5
  }
  </code></pre>
  
  <p>I there a way to sort the row depending on the <code>number</code> in the JSON object?</p>
  
  <p>I know that I can do it programmatically, but I was just wondering if there was an SQL alternative.</p>