update more than one at a time mysql

Update tablename SET filedname='test' Where id IN(001,002,1001069,1001100)