title: MySQL Order by boolean value tinyint
body: <p>I am using mysql  Ver 14.14 Distrib 5.5.31, for debian-linux-gnu (x86_64).</p>
  
  <p>This query fails with a <code>You have an error in your SQL syntax[...]near 'read ASC'</code> message :</p>
  
  <pre><code>SELECT 'messages'.* FROM 'messages' WHERE 'messages'.'user_id' = 2 ORDER BY read ASC;
  </code></pre>
  
  <p>where the <code>read</code> column is a <code>TINYINT(1)</code> value generated by the Rails ActiveRecord interface to store boolean values. </p>
  
  <p>The same action works when switching to postgresql, but i currently have no access to the pg generated queries.
    Is there something wrong with the actual query? (maybe i cannot order by a tinyint) or should I file a bug report?</p>