title: How to arrange VARCHAR column?
body: <p>I have table which contain varchar column .This table will be used for pagination.
  please see SQL Fiddle for the table structure.</p>
  
  <p><a href="http://sqlfiddle.com/#!2/db5467/53" rel="nofollow">http://sqlfiddle.com/#!2/db5467/53</a></p>
  
  <p>It contain column <code>g_season</code> now when i fired query</p>
  
  <pre><code>SELECT * FROM(SELECT * FROM Games WHERE g_season &gt; 'cvxv' ORDER BY g_season ASC ) s LIMIT 1
  </code></pre>
  
  <p>it gives me correct <code>g_id=7</code> but when i put 'dasd' it gives me <code>g_id=10</code> but it should be <code>g_id=12</code> this is because 7 and 12 <code>g_id</code> column contain g_Season and 'dasd' and sql will fetch last matching row and it is nothing but the <code>g_id=10</code></p>