My table has the following results

col1 col2 col3

test1 10 OK

test1 10 DEL

test2 5 OK

this is the way I have this moment where col3 data are OK or DEL

I wanted the result to be:

col1 col2 col3

test1 10 OK

test1 0 DEL

test2 5 OK

ie, when the field was col3 DEL, put to zero the value of col2