title: Get first row in mysql query
body: <p>I want to return the first row in mysql result</p>
  
  <p>I have a query with order by resulting in 3 rows to be returned but i only want to return the first row</p>
  
  <pre><code>select nondox
       , account
       , id 
    from rates2test 
   where weight = 1 
     and country_code='AF' 
     and service='INT' 
   order 
      by nondox asc 
   limit 1
  </code></pre>
  
  <p><strong>Table</strong></p>
  
  <pre><code> nondox, account, id
  '51.47', '610533699', '2'
  '51.47', '610798706', '950042'
  '51.47', '610662766', '1941032'
  </code></pre>
  
  <p>Expected: should return first row
  Actual: Returns the last row</p>