title: `UPDATE` and `LIMIT` in `MySQL`
body: <p>I would like to update a specific range of rows, say starting from <code>30</code> and ending at <code>50</code>. How may I achieve that.</p>
  
  <p>I have tried with:</p>
  
  <pre><code>UPDATE tab
  SET    col = 'somevalue' 
  LIMIT 30, 50
  </code></pre>
  
  <p>but this doesn't work. Is there any way that I can update these rows?</p>
  
  <p>The error that I get is:</p>
  
  <blockquote>
    <p>Check the manual ... for the right syntax to use near ' 50'</p>
  </blockquote>