title: Mysql ORDER BY numbers DESC
body: <p>I have a simple mysql select query in my PHP code:</p>
  
  <pre><code>$result = mysql_query("SELECT text FROM example ORDER BY rank DESC");
  while($row = mysql_fetch_array($result))
    {
    echo $row['text'] . "&lt;br&gt;";
    }
  </code></pre>
  
  <p>and this MySql table:</p>
  
  <pre><code>   text | rank
  --------+--------
   google | 245
  --------+--------
   yahoo  | 32
  --------+--------
   bing   | 12
  </code></pre>
  
  <p>When I get the results from the query, something like this gets displayed:</p>
  
  <pre><code>yahoo 
  google
  bing
  </code></pre>
  
  <p>I want Google to be in front. I guess Yahoo is in first because it starts with "3".</p>
  
  <p>How could I make the query order the results by the size of the numbers in rank?</p>
  
  <p>Thanks...</p>