Hi,
Does anyone know a way to do multiple unique updates in one query, the way you can in an insert query? I have a table with several thousand records. Periodically every record in this table needs one field to be updated. Slows down the process if each record is updated with a separate query. mysql Andrew Hazen, O.C.P. E-Commerce Developer Jatech Solutions Inc. www.jatech.ca Specializing in OSCOMMERCE applications and PHP/MySQL programming.