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:[EMAIL PROTECTED] > Sent: Saturday, March 18, 2006 3:29 PM > To: mysql@lists.mysql.com > 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/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
