On 18/04/16 14:32, Alan Lord wrote: > > UPDATE vtiger_crmentity SET deleted = 0 WHERE modifiedtime < 'before I > deleted 19,000 records' AND modifiedtime > 'when I finished deleting > 19,000 records'; Sorry just noticed I got my < and > round the wrong way but I'm sure you noticed that already ;-) Al