It is possible to invert the value in mysql table without knowing the present value. This working on mysql and may not work on postgresql.


UPDATE table_name SET column = NOT column