window.ENTITIES={'/api/snippets/sql/mysql%20update%20query%20with%20limit':[{"result":true,"message":null,"batch":{"type":"sql","name":"mysql update query with limit","items":[{"id":"DL7BZ1","type":"sql","name":"MySQL UPDATE query with LIMIT","content":"UPDATE `users` SET `department_id`= 10\nWHERE `id` IN (\n    SELECT `id` FROM (\n        SELECT `id` FROM `users` \n        ORDER BY `id` ASC  \n        LIMIT 3, 4\n    ) subquery\n);","source":"https://dirask.com/posts/MySQL-UPDATE-query-with-LIMIT-Dl0w4D","author":{"id":"YobPpD","name":"leila","avatar":"1629142981931__YobPpD__w40px_h40px.jpg","points":435,"role":"BASIC"},"creationTime":1635177040000,"updateTime":null,"removalTime":null}]}}]};