CODE EXAMPLE FOR SQL

set all the vluses in calumn in sql to false

UPDATE YourTableName
SET IsConfirmed=0
WHERE isConfirmed is Null