UPDATE table SET field = NULL WHERE something = something
SELECT * from TABLE where CODE IS NULL OR CODE!='C'
SELECT contactname, IFNULL(bizphone, homephone) phone FROM contacts;