mysql - UPDATE with LIMIT x, y

Question

UPDATE table SET checked = 1 WHERE field = 'xxx' LIMIT 1

works fine, but

UPDATE table SET checked = 1 WHERE field = 'xxx' LIMIT 1, 10

throw error "#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"

Why it is not possible? I want to update everything except first row.

Answer 1

update table set checked = 1 where id in (select * from (select id from table where field = 'xxx' order by id limit 1, 10) as t)