title: mysql - UPDATE with LIMIT x, y
body: <pre><code>UPDATE table SET checked = 1 WHERE field = 'xxx' LIMIT 1
  </code></pre>
  
  <p>works fine, but</p>
  
  <pre><code>UPDATE table SET checked = 1 WHERE field = 'xxx' LIMIT 1, 10
  </code></pre>
  
  <p>throw error "<em>#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 10' at line 1</em>"</p>
  
  <p>Why it is not possible? I want to update everything except first row.</p>