And note that assignments are evaluated left to right, so the value of
bounce_count has already been incremented when we get to the status
assignment. Adjust accordingly.
Michael
Michael Stassen wrote:
How about
UPDATE table
SET bounce_count = bounce_count+1,
status = if(bounce_count
How about
UPDATE table
SET bounce_count = bounce_count+1,
status = if(bounce_count > 9, 'bounced_out', status)
WHERE ...;
Michael
Scott Haneda wrote:
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
i
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 > 1
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 Ha
