title: mysql sort alphabetical and number
body: <p>I have an array that I want to sort alphabetically but also by the number at the end. </p>
  
  <pre><code>"SELECT DISTINCT Number FROM database WHERE 1 Order By Number ASC";
  </code></pre>
  
  <p>Here is how it currently sorts:</p>
  
  <pre><code>Number 1
  Number 10
  Number 11
  Number 2
  Number 3
  Number 4
  Number 5
  Number 6
  Number 7
  Number 8
  Number 9
  The End
  </code></pre>
  
  <p>This is how I want it to sort:</p>
  
  <pre><code>Number 1
  Number 2
  Number 3
  Number 4
  Number 5
  Number 6
  Number 7
  Number 8
  Number 9
  Number 10
  Number 11
  The End
  </code></pre>