UPDATE TABLE set value=0 WHERE value=1