Shane Dowling : Useful bit of SQL to update many records in SugarCRM

UPDATE clowns SET deleted=1 WHERE id IN
 (SELECT id FROM (
 SELECT id FROM clowns WHERE deleted = 0 ORDER BY id ASC LIMIT 0, 800)
 tmp );