MySQL - UPDATE query with LIMIT - 7-Views

Many a times there are certain conditions where ou want to update your records with certain limit attached to it.

To update multiple rows using limit in MySQL can be implement by a query:

UPDATE table_name SET field='1' WHERE id IN (SELECT id FROM (SELECT id FROM table_name LIMIT 0, 10) tmp);