title: LIMIT offset or OFFSET in an UPDATE SQL query
body: <p>I have a table similar to this:</p>
  
  <pre><code>| 0 | X  |
  | 1 | X  |
  | 2 | X  |
  | 3 | Y  |
  | 4 | Y  |
  | 5 | X  |
  | 6 | X  |
  | 7 | Y  |
  | 8 | Y  |
  | 9 | X  |
  </code></pre>
  
  <p>I'd like to replace first 2 occurrences of <code>X</code> with <code>X1</code>, and then 4 next occurrences with <code>X2</code> so that the resulting table looks like this:</p>
  
  <pre><code>| 0 | X1 |
  | 1 | X1 |
  | 2 | X2 |
  | 3 | Y  |
  | 4 | Y  |
  | 5 | X2 |
  | 6 | X2 |
  | 7 | Y  |
  | 8 | Y  |
  | 9 | X2 |
  </code></pre>
  
  <p>The table in question is of course much bigger and the number of occurrences would thus be higher too so manual editing is not a solution.</p>
  
  <p>I'd like to do something like this:</p>
  
  <p><code>UPDATE table SET column = 'X' WHERE column = 'X2' LIMIT 90, 88</code></p>
  
  <p>but unfortunately MySQL doesn't seem to support OFFSET in UPDATE queries... Is there any way to do this?</p>