Is there a way to write an if statement in mysql to affect the following?...

if field a=0,b=0,c=0 then update d='complete' 

where the table consists of...

a int(1),
b int(1),
c int(1),
d char(8)

--------------------
|a  |b  |c  |d     |
--------------------
|1  |0  |0  |null  |
|1  |1  |0  |null  |
|0  |0  |0  |null  |
--------------------

resulting with the third recode updated to show 'complete'?

TIA

Larry


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to