I think , You should do following : update weld_details set parent = '1' where db_uid = '1' or db_uid = '2'
Ben Cairns wrote: > I want to update a MySQL db table, but I want to update multiple records, > > Like this: > > I want to run a statement like this: > update weld_details set parent = '1' where db_uid = '1','2' > > Now, it dont work, and I cant see why, I think it has something to do with the > numbers at the end of the statement. But I cant see what... > > Pls help. > > Thanks in advance. > > -- Ben Cairns - Head Of Technical Operations > intasept.COM > Tel: 01332 365333 > Fax: 01332 346010 > E-Mail: [EMAIL PROTECTED] > Web: http://www.intasept.com > > "MAKING sense of > the INFORMATION > TECHNOLOGY age > @ WORK......" > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]