title: Sort results in varchar column with Postgres
body: <p>I have theses values in my table</p>
  
  <pre><code>id | NAME
  1 | 20 MEGA
  2 | 30 MEGA
  3 | 10 MEGA
  4 | 300 MEGA
  5 | 100 MEGA
  6 | 25 MEGA
  </code></pre>
  
  <p>What i want:</p>
  
  <pre><code>id | NAME
  3 | 10 MEGA
  1 | 20 MEGA
  6 | 25 MEGA
  2 | 30 MEGA
  5 | 100 MEGA
  4 | 300 MEGA
  </code></pre>
  
  <p>I tried this query:</p>
  
  <p>select * from table_name ORDER BY "name" ASC </p>
  
  <p>But returns </p>
  
  <pre><code>3   10 MEGA
  5   100 MEGA
  1   20 MEGA
  6   25 MEGA
  2   30 MEGA
  4   300 MEGA
  </code></pre>
  
  <p>How can i do this?</p>