- Original Message -
From: "Rich" <[EMAIL PROTECTED]>
To:
Sent: Saturday, March 18, 2006 6:28 PM
Subject: Update Multiple Records
Hi folks.
I want to set the status of 5 records to 'completed'. how do I go about
that without having to prepare 5 differe
ords should you have mistyped a query. Plus it will
speed up your SELECTS if you only need to pull 1 record say.
> -Original Message-
> From: Rich [mailto:[EMAIL PROTECTED]
> Sent: Saturday, March 18, 2006 3:29 PM
> To: mysql@lists.mysql.com
> Subject: Update Multiple Records
&g
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
--
