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 RecordsRich19 Mar
  • RE: Update Multiple RecordsDaevid Vincent19 Mar
  • Re: Update Multiple RecordsRhino19 Mar