title: update multiple rows using limit in mysql?
body: <pre><code>    UPDATE messages set test_read =1 
          WHERE userid='xyz' 
          ORDER BY date_added DESC  
          LIMIT 5, 5 ;
  </code></pre>
  
  <p>I am trying to use this query to update a set of 5 rows using limit but mysql is showing an error..The one below is working</p>
  
  <pre><code>    UPDATE messages set test_read =1 
          WHERE userid='xyz' 
          ORDER BY date_added DESC  
          LIMIT 5 ;
  </code></pre>
  
  <p>why is the first one not working? </p>