title: sql order by from highest to lowest value
body: <pre><code>SELECT * FROM highscore ORDER BY score
  </code></pre>
  
  <p>This code always sorts my values for lowest to highest but I want them from the highest to the lowest.</p>
  
  <p>Actually I have two sets of data in my table and I always get:</p>
  
  <pre><code>0
  235235
  </code></pre>
  
  <p>But I need it to be like this:</p>
  
  <pre><code>235235
  0
  </code></pre>
  
  <p>I have already tried:</p>
  
  <pre><code>SELECT * FROM highscore ORDER BY CAST(score AS int)
  </code></pre>
  
  <p>But that gave me a syntax-error:</p>
  
  <blockquote>
    <p>"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INT)' at line 1"</p>
  </blockquote>
  
  <p>In my table score is set as <code>int(100)</code>.</p>
  
  <p>Does anybody have a solution how I could sort them like that? There will never be negative or non-int values.</p>