mysql update query with limit

1
2
3
4
5
6
7
8
UPDATE `users` SET `department_id`= 10
WHERE `id` IN (
    SELECT `id` FROM (
        SELECT `id` FROM `users` 
        ORDER BY `id` ASC  
        LIMIT 3, 4
    ) subquery
);