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]
