Scott, This may work for you:
UPDATE tableName SET bounce_count = bounce_count +1, status = 'bounced_out' WHERE (bounce_count + 1) > 10; UPDATE tableName SET bounce_count = bounce_count + 1 WHERE status <> 'bounced_out' AND (bounce_count + 1) <= 10; You might want to lock the table while you run those to ensure that nothing else is breaking the atomicity of the queries. If you are using InnoDB you would wrap it in a transaction. Lachlan -----Original Message----- From: Scott Haneda [mailto:[EMAIL PROTECTED] Sent: Wednesday, 11 August 2004 8:28 AM To: MySql Subject: Update on condition I need to do a certain update based on a condition: MySql4 Update table set bounce_count = bounce_count+1 is the basic query, somewhere in there I need to only do a if bounce_count+1 > 10 then update status = 'bounced_out' -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- 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]