| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Rich | Date: | March 18 2006 11:28pm |
| Subject: | Update Multiple Records | ||
| View as plain text | |||
Hi folks. I want to set the status of 5 records to 'completed'. how do I go about that without having to prepare 5 different instructions? "update myTable set status = 'completed' where id=10 OR id=20 OR id=30 OR id=40 OR id=50" I'm trying to reduce the number of instructions. Cheers
| Thread | ||
|---|---|---|
| • Update Multiple Records | Rich | 19 Mar |
| • RE: Update Multiple Records | Daevid Vincent | 19 Mar |
| • Re: Update Multiple Records | Rhino | 19 Mar |