I am trying to work out how to update a number of records in 1 transaction.

Normally in MS SQL SERVER I would go 

```
Update table
set status 'YES' where ID in ('1', '2', '3', '4', '5', '6', etc)

```

However in MYSQL i can't work out the right syntax.

Can I use less than, between than operators? `>= and <=` ?
Or can I use like I have done in the above statement, using `where "ID" in ('','','','')`