UPDATE table1 SET column_a = NULL WHERE column_b = 'XXX';
-- To change a column to nullable ALTER TABLE mytable ALTER COLUMN mycolumn DROP NOT NULL;