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]
