title: How to sort MySQL query records from big to small numbers
body: <p>I'm trying to sort my records from big to small numbers, here are my example records:</p>
  
  <pre><code>id   name   view   like
  1   name1    5      1
  2   name2    2      4
  3   name3    41     3
  4   name4    6      31
  5   name5    1      2
  </code></pre>
  
  <p>For example, I want the order the records like this (i.e. ordered by the field named <code>like</code>):</p>
  
  <pre><code>id   name   view   like
  4   name4    6      31
  2   name2    2      4
  3   name3    41     3
  5   name5    1      2
  1   name1    5      1
  </code></pre>
  
  <p>I tried this query...</p>
  
  <pre><code>SELECT * FROM tablename ORDER BY like DESC
  </code></pre>
  
  <p>...but the query result is like this now:</p>
  
  <pre><code>id   name   view   like
  2   name2    2      4
  3   name3    41     3
  4   name4    6      31
  5   name5    1      2
  1   name1    5      1
  </code></pre>
  
  <p>So, what is the correct query for what I want?</p>