I have list of records displayed in repeating grid, user want to do bulk action like update 10 rows or 20 rows.  how to do this bulk action in single DB interaction.

sample expected update query.

UPDATE table_name
 SET column1="UPDATESTATUS"
 WHERE some_column in ("id100","id200","id300")