update myTable set status = 'completed' where id IN (10,20,30,40,50) LIMIT
5;
I believe that should work.
As a precaution, I recommend always using "LIMIT x" whenever possible on
SELECT, UPDATE or DELETE statements. This will minimize any accidental
dammage to other records 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:lists@stripped]
> Sent: Saturday, March 18, 2006 3:29 PM
> To: mysql@stripped
> 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 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
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>
